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