Help Needed for finding a value

  • Thread starter Thread starter TGV
  • Start date Start date
T

TGV

Anyone please tell me in A colum some texts are available with Question Mark
(?) i want to find the cells which are all consist the question mark (?).

If i press control + f and mention the question mark (?) for finding the
cells which consist the (?) marks but it's goes to all of the cells. I know
that ? mark used as an expression and it means the condition of "any
character" So it's going to all cells.

So please give me a solution like function or using some other keywords to
find it in find option.

Please send it immediately i want it in urgent basis.

Thanks in advance.

TGV
 
As it is a single wildcard character, if you want to use it in CTRL-F
or CTRL-H then you must preceed it with the tilde symbol, ~

So, Find what: ~?

will look for that specific character.

Hope this helps.

Pete
 
Hi,

Excel teats ? as a wildcard so preceed it with a tilde ~ in the search box
i.e. find ~?

Mike
 
Thank you very Much!!!

TGV

Pete_UK said:
As it is a single wildcard character, if you want to use it in CTRL-F
or CTRL-H then you must preceed it with the tilde symbol, ~

So, Find what: ~?

will look for that specific character.

Hope this helps.

Pete
Click to expand...
 
Back
Top