Excel - Delete text up to a particular character

October 2016


Is there a way of deleting all the text up to a certain character under Excel?
  • I am trying to import a CSV file to Exchange and need to modify some text first. So for example in Excel I could have a entries like:
    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.


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.

Related :

This document entitled « Excel - Delete text up to a particular character » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.