Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Brantford, Ontario, Canada
    Posts
    2,391
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Searching / Replacing

    How can I search through raw text, imported to Excel for the characters double questionmarks (??)

    The Search/Replace commands treat the questionmarks as wildcards, but I need them to be treated as text, or plain characters.

    The data is generated by a separate piece of hardware, and reports the "??" when it encounters an error. I need to run averages, sums, maximums, etc. on the rest of the data.

    Any help would be a great help.
    Christopher Baldrey

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Searching / Replacing

    You have to preface each ? with a tilde (~). This signals that you what the following character as a literal. So to seach for ?? you would enter ~?~?

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Brantford, Ontario, Canada
    Posts
    2,391
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Searching / Replacing

    [img]/w3timages/icons/clever.gif[/img]Thanks for your help! It was the <font color=red>perfect</font color=red> solution.

    Gee... less than an hour to get <font color=red>good support</font color=red>. That's better than phoning Microsoft!
    Christopher Baldrey

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Searching / Replacing

    And not nearly as expensive as $245 per call.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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