How to strip away anything beyond a specific character:

[Wulf]

Example:
Aztec Steel - Coil Springs ~ Advanced Reporting

Thousands of entries exist with this '~' behind the numerous companies in this column list, indicating the title of a submitted help ticket.

'Ctrl' 'H' will get me the find and replace, but how do I strip away EVERYTHING past the '~', including the '~', all the way down the column, quickly?

Thank you.

 

[Eric W]

Insert an empty column to the right of the column with your data. Go to the Data tab, click Text to Columns, check delimited > Next > uncheck everything > check Other, and put a ~ in the box. Click Finish. Now just delete the new column.

Hope this helps.

 

[mumps]

Assuming your data is in column A starting in row 1, place this formula in B1 and copy it down as far as you need it: =LEFT(A1,(FIND("~",A1,1)-1))