I have in this amazing forum found a formula to extract a textstring before a special character.
In this case I want the text before the "." dot
=LEFT(A1,FIND(".",A1,1)-1)
This works perfectly, but not for an E-mailadress.
Is there anyone that can find a formula that extract the text before the first dot in an E-mail adress
Thank's in advance
Please show samples with expected output...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
The first dot in an email address is before the last word. Isn't it? Let's say
[email protected]
Your formula gives as result this.
Someone@gmail
Isn't this your expected result?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Worked fine for me:ExampleII.xlsx
Sorry, I was looking for a missing comma in the email adress.
The formula =LEFT(A1,FIND(".",A1,1)-1) is working with e-mail adresses with personal names.
Thread solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks