M-
I have it running. It takes about 5 minutes to loop through all the cells. It did not change all of them. I am not sure if it ran out of memory? Also I found there are a records that are need to be changed that do not have a space, example 2Pnt.
I am not sure how difficult it will be to factor this in.
Since I have no idea what went into this, I am throwing this out for consideration, what about using an auto-filter in the code and then do the replace that way. Is that possible?