LinkBack URL
About LinkBacks
How to extract email lumped in the same cell with other data?
That is how a cell with combined data looks like:
"1690","test@hotmail.com","898"
Seriously ,Help!
Todor
How to extract email lumped in the same cell with other data?
That is how a cell with combined data looks like:
"1690","test@hotmail.com","898"
Seriously ,Help!
Todor
Last edited by todorko; 05-16-2013 at 03:08 PM.
Does it includes ""?
How does the "data" looks like?
- [1.]"1690","test@hotmail.com","898"
[2.]1690,test@hotmail.com,898
[3.]test@hotmail.com898
Post a sample of your excel, so that others could be able to help you out.
Hi,
Thank you for replaying:
[1.]"1690","test@hotmail.com","898"
Todor
=MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,"""",CHAR(7),3))+1,FIND(CHAR(7),SUBSTITUTE(A1,"""",CHAR(7),4))-FIND(CHAR(7),SUBSTITUTE(A1,"""",CHAR(7),3))-1)
it's a bit messy, but it works for this data set...HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
How about
=SUBSTITUTE(MID(A1,FIND(",",A1)+1, FIND(",",A1,FIND(",",A1)+1)- FIND(",", A1)-1),CHAR(34),"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi,
I am getting that the formula contains an error. I did substitute commas with semi-colons, it did not work
See attachment
as per post 5
My bad, it works fine!
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks