Is there a way of deleting all the text up to a certain character under Excel?
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.