| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Find&Replace with MatchWholeWord?
Hi All:
I need to Find and Replace text in excel, however I'm bumping into a problem: parts of longer words are being found by shorter words and these parts are being then replace with the ReplaceWith text. Word's VBA has the "MatchWholeWord Property" that avoids this problem. Does anyone know if there is a way to do this "MatchWholeWord" in Excel VBA? Thanks for your help, JS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Using Find and Replace to replace " in a macro | Excel Programming | |||
| Replace method - cannot find any data to replace | Excel Programming | |||
![JS[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
