• Russlens
    a year ago

    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?

  • Deanpanorama_fish_eye
    a year ago

    find and replace " - " with nothing?

  • Russlens
    a year ago

    If it's that simple I'm going to be both delighted and furious.

    Edit: motherfucker it was. Thank you. Now very annoyed at myself.

  • Jim7lens
    a year ago

    The hours I’ve wasted…..
    Forehead-smacking emoji

Search
  • Enter search query (at least 3 characters).

Your options