Can i delete text up to a character in excel
Solved/Closed
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 ?
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 ?
Related:
- Can i delete text up to a character in excel
- Pipe character mac - Guide
- Dino game custom character - Guide
- Number to words in excel - Guide
- Special character letter - Guide
- Gif in excel - Guide
2 responses
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.
This will give you 2 columns and you can delete the left one.
Jun 16, 2010 at 01:36 PM
Dec 13, 2011 at 11:15 AM