vba to find and replace exact matches of cell value in a sheet

[Rem0ram]

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]

[VBA]cells.replace ".","",xlwhole[/VBA]

[Rem0ram]

Hi

Many Thanks!

You Rocked.

Best
Rem0

[pmyk]

@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.