PDA

View Full Version : vba to find and replace exact matches of cell value in a sheet



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

snb
02-26-2013, 05:38 AM
cells.replace ".","",xlwhole

Rem0ram
02-26-2013, 09:41 AM
Hi

Many Thanks!

You Rocked.

Best
Rem0

pmyk
09-05-2019, 10:10 PM
@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.:yes