Results 1 to 3 of 3
  1. #1
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Replace * and ? (2002)

    I know someone must have run into this problem before that can help me.

    I have a row of 40,000 records and I need to search a column to replace any * with a blank using the Edit | Replace menu. I need to do the same thing with ?. What I think Excel is doing is building a search with Like(*) so it replaces everything in the column with a blank instead of just those that have the *. I lose all my data.

    Is there anyway to have Excel do this replace correctly?

    I haven't tried this yet but I probably could save it as a csv file and do the changes there are then import it back to Excel. But I would like to find a way to do it in Excel.

    Thanks.
    You know it's time to diet when you push away from the table and the table moves.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Replace * and ? (2002)

    XL: How to Find and Replace Tildes and Wildcard Characters shows how to do this from within Excel.

  3. #3
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Replace * and ? (2002)

    Thank you Tony. So it's the tilde character? I would never have guess that one. Thanks again.
    You know it's time to diet when you push away from the table and the table moves.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •