-
vba to find and replace exact matches of cell value in a sheet
Hi
I trying to write a macro to find and replace only the exact matches in a sheet.
Example:
The sheet contains cell values like 1.01.test value, 1.1.02.test value, and most of cells value will be "."
Now i want to clear only the "." dots in the sheets but don't want to delete the dots in 1.01. or 1.1.02. etc.
Any help will be really great.
Best
Rem0
-
[VBA]cells.replace ".","",xlwhole[/VBA]
-
Hi
Many Thanks!
You Rocked.
Best
Rem0
-
@snb Fantastic. It is mind-boggling to see all exact match cells in a Sheet are replaced with the desired string while the partial match cells are not modified.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules