I have a list of around 700 names in an Excel spreadsheet. Because this list was cut and pasted from a pdf, each entry has a bullet point character in front of it so it looks like this:
- Russ
- JimShady
- tricky
- noodle
in order to do a de-duplication against a different database I need to remove the bullet character at the beginning of each entry. Is there a simple command that will do that and save me the infuriatingly tedious task of doing each one individually?
