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

Question

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 ?

hm · Accepted Answer

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.

clinchitb · Answer

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.

Can i delete text up to a character in excel

2 responses

Subscribe To Our Newsletter!