| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find replace text or symbol with carriage return | New Users to Excel | |||
| find replace ??* | Excel Worksheet Functions | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
| Find & Replace results to display specified chosen fields | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Hybrid Mode
