Hi Excel Experts,
I have a spreadsheet with a column named "Event". "Event" has about 300 rows in it with data that look like this:
In some cases the numbers have 3 digits, in some they have 2 digits
I want to remove the digits before the semicolon. Also the semi colon should be removed.
The end result would have data that looks like this
I'm using Microsoft Office 365
I'd appreciate any solutions you can give me.