Remove * from value

[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

 

[Yanick]

=SUBSTITUTE(A1,"*","")

Replace A1 with the needed cell.

 

[PCLIVE]

In your 'Find what' dialog, preceed the asterisk with a tilde (~).

ex. - ~*

This is located above the Tab key.

HTH,
Paul

 

[Yanick]

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

Any-way... I will not forget this trick!

 

[PCLIVE]

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

--

 

[Yanick]

It is in fact good to know!

Thank you,