Rem0ram
02-26-2013, 04:27 AM
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
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