Detect Number of Occurence's Of A Specific Character & Delete The First One

Hi, I'm trying to count a specific character, if the specific character in the string occurs higher then 2, then delete the first time it occurs in a string

The position of the first decimal point has to detected dynamically, as I have hundred of numbers in a text file.

Ie., First detect if 11.356.11 contains two decimal points, then delete the first decimal point, so it reads 11356.11

Note the first decimal point has to detected dynamically, as I have hundred of numbers with multiple decimal points, in a text file.


Ive managed to detect if a string contains two decimal points, but cant figure out how to delete the first. Note the first decimal point has to be detected dynamically, as I have hundreds of numbers with multiple decimal points, ie 1.23.1 23.345.34 etc.

Thanks.,

Please Login or Register  to view this content.

Assuming your data is in Column A starting at cell A1 (change the red highlighted text if this assumption is wrong), this non-looping macro will make the changes you asked for...

Please Login or Register  to view this content.

Thanks guys