how do i pull only the email address from a cell that is like this:
[email protected],anna,stone,,,,,,,,,,,2011-10-20 17:31:08
how do i pull only the email address from a cell that is like this:
[email protected],anna,stone,,,,,,,,,,,2011-10-20 17:31:08
Hi RGREGCREWS and welcome to the forum
If email address is always in the beginning and is separated by comma from the rest of the string, you can use formula below.
Assuming string is in A1
=TRIM(LEFT(SUBSTITUTE(A1,",",REPT(" ",255)),255))
A B 1[email protected],anna,stone,,,,,,,,,,,2011-10-20 17:31:08 [email protected] 2
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks