ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wild Cards in Find and Replace (https://www.excelbanter.com/excel-discussion-misc-queries/10833-wild-cards-find-replace.html)

Jason Graf

Wild Cards in Find and Replace
 
Can I use # symbol in a search and replace as a wildcard?

I have an if statement I want to change to and equals statement but I don't
want to have to replace all 200+ entries manually.

TIA

Jon



Ben Hawkins

Simple answer is no. You can use ? to replace a single character or * to
replace multiple characters.
Eg. H?L finds all 3-letter words beginning with H and ending with L; H*L
finds all words beginning with H and ending with L.
"Jason Graf" wrote in message
...
Can I use # symbol in a search and replace as a wildcard?

I have an if statement I want to change to and equals statement but I

don't
want to have to replace all 200+ entries manually.

TIA

Jon






All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com