1
Thanks

A few words of thanks would be greatly appreciated.

Delete Text up to a Particular Character in an Excel Document

There are many different tips and tricks when using Excel. In this article we're going to show you how to delete all the text up to a certain character when importing data to your Excel document.

How to Delete Text up to a Specific Character

  • 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.


Image © Sasirin Pamai - 123rf.com
1
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Delete Text up to a Particular Character in an Excel Document », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

0 Comments