Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel find/replace should allow values to be pasted in. | Excel Worksheet Functions | |||
Find/Replace - Full Navigation of Spreadsheet | Excel Discussion (Misc queries) | |||
Find/replace | Excel Discussion (Misc queries) | |||
find/replace enters | Excel Discussion (Misc queries) | |||
How to find/replace data in column | Excel Discussion (Misc queries) |