|If all the data your trying to remove is of the form:|
Semicolon Hashtag numbers
Select Home Tab
Select Find & Select (last box on the right)
In the Find What box enter: ;*
That is a semi-colon followed by a star.
The star is a wild card that matches any character.
In the Replace With box, leave blank
Then, just Select All
See how that works.
message edited by mmcconaghy