Results 1 to 5 of 5

Thread: Search function

  1. #1
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Whenever I try doing a cntrl+f function to search for question marks in my spreadsheet, it takes me to each and every cell, even though they don't all have question marks. When I search for a word comprised of letters, though, it takes me to only the cells with those words in them. How can I make the former function like the latter?

    REgards,

    JMT

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You mention 'spreadsheet' but you posted your question in the Microsoft Outlook forum. Should it have been posted in the Spreadsheets forum?

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Due to te reference to Spreadsheets, this has been moved to the Spteadsheets Forum.
    Gre

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In Excel, the ? and * characters act as wildcards in a search: ? stands for a single character, * stands for any number of characters.

    So for example, searching for D?n will find Dan and Don but not Ran, and searching for D*n will find Dan and Dean and Dogon but not Dear.

    If you want to search for ? or * as a character, precede it with a tilda ~.

    So to search for What? including the question mark, enter What~? in the search box.

  5. #5
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans. Sorry about that; I meant to post this in Excel.

Posting Permissions

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