Can i delete text up to a character in excel [Solved/Closed]

Report
-
 Mahek -
Hello,
Is there a way of deleting all the text up to a certain character in excel. i im trying to import a CSV file in to exchange and need it tyding up first. So for example in excel I could have a entry of
X400:c=GB;a=NHS;p=NHS N West HN;o=NHS North West Lancs HA;s=Robin;g=Alayne;ou1=Health Promotion Unit;%SMTP:RobinAlayneQCYNWLancsHA@gp-P81081.nhs.uk

Is there any way of deleting all the text left of the % character. I have tried the LEFT and RIGHT commands but have to specify the number of characters, but need to do this for thousands of entries ?

2 replies

You are also able to do text to columns - highlight the column, on the data tab select "text to columns," choose the "delimited" radio button, and then select the character in your cell or enter it in the blank field.
This will give you 2 columns and you can delete the left one.
10
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Wow. Nice one. You rock!
Thank you!!. Helped me as well
If the character is always the same (i.e. the %) have a look at the FIND command, which you can then combine with LEFT or RIGHT to extract.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!