Is this right?

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

Can't quite believe this... suspect something wrong here but maybe
someone could confim?

Select a Column and Hit Control-F

The Find What: search criteria is FT~SU

Excel reports:

Microsoft Excel cannot find the data you're searching for. Check your
search options, location and formatting.


I'm searching With Sheet and By Row and have tried all 3 LookIn
options, and with all comnbinations of the Match boxes.

The string is present and correct, I even copied it from the cell and
pasted directly into 'Find What:'.

Very perplexing! Should this work? I can find other things OK.

Thanks - Kirk
 
Use this to search with... FT~~SU

Why? Because the tilde (~) has special meaning to the Find function... it
means "use the next character exactly as is" (needed to be able to search
for wildcard characters that are not being used as wildcards), so to take
away ITS special meaning, you precede the tilde with a tilde.
 
Back
Top