![]() |
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 |
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