Excel - Delete text up to a particular character

August 2017



Issue



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.

Solution


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


Published by aakai1056. Latest update on December 14, 2011 at 03:39 AM by aakai1056.
This document, titled "Excel - Delete text up to a particular character," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).