Find/Replace *
 

How do I specify an * (asterisk) as a search expression?

* is used as a wildcard for Excel and other MS tools and I need to
subsistitute an '*' for 'a' on a spredsheet.

TIA,
--
Where I am:

East Zone - São Paulo - SP - Brazil - South America - Earth Planet - Solar
System - Milky Way

Find/Replace *
 

Prefix it with a tilde ~

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"W Barbosa" wrote in message
...
How do I specify an * (asterisk) as a search expression?

* is used as a wildcard for Excel and other MS tools and I need to
subsistitute an '*' for 'a' on a spredsheet.

TIA,
--
Where I am:

East Zone - São Paulo - SP - Brazil - South America - Earth Planet - Solar
System - Milky Way

Find/Replace *
 

Use ~* as search argument

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"W Barbosa" wrote in message ...
| How do I specify an * (asterisk) as a search expression?
|
| * is used as a wildcard for Excel and other MS tools and I need to
| subsistitute an '*' for 'a' on a spredsheet.
|
| TIA,
| --
| Where I am:
|
| East Zone - São Paulo - SP - Brazil - South America - Earth Planet - Solar
| System - Milky Way

Find/Replace *
 

Precede the * by a tilde in your search expression: ~*
--
David Biddulph

"W Barbosa" wrote in message
...
How do I specify an * (asterisk) as a search expression?

* is used as a wildcard for Excel and other MS tools and I need to
subsistitute an '*' for 'a' on a spredsheet.

Find/Replace *
 

Thanks for everyone for the answers! :-)

I just can't believe I couldn't find it in help...
--
Where I am:

Center Zone(@work!) - São Paulo - SP - Brazil - South America - Earth Planet
- Solar System - Milky Way


"W Barbosa" escreveu:

How do I specify an * (asterisk) as a search expression?

* is used as a wildcard for Excel and other MS tools and I need to
subsistitute an '*' for 'a' on a spredsheet.

TIA,
--
Where I am:

East Zone - São Paulo - SP - Brazil - South America - Earth Planet - Solar
System - Milky Way