I have a .csv file that has included names after email addresses and I need an easy way to get rid of the names. Example - [email protected] John Smith ([email protected])
I only want to retain the [email protected] and delete everything that comes after the first space. I am an Excel beginner so am not real comfortable with formulas!
An example workbook (Go Advanced> Manage Attachments) showing how your data is laid out in the crv would help.
If your data is in A1
=MID(A1,1, Search(" ", A1))
Then copy and paste special> values to remove the formula
Does that help?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks