Remove * from value

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Is there anyway using find and replace if I have a number and then an *.
Example> 5* How can I replace the '*' from the field so that the formula
MAX will work. Any way please. Thanks
 
In your 'Find what' dialog, preceed the asterisk with a tilde (~).

ex. - ~*

This is located above the Tab key.

HTH,
Paul
 
Did not know about the "~" trick. Is "~" used to specified that the next
caractere is text?

Any-way... I will not forget this trick!
 
It basically tells Excel that the next character is a literal. This can be
used for an asterisk (*), a question mark (?), or even another tilde (~).
When trying to find a tilde (~), you would actually find (~~).

It's kind of a cool thing to know.

Regards,
Paul

--
 
Back
Top