Hi and thanks in advance,
I am using Excel 2003
I have a sheet that has in column A some long strings and I want a quick way, preferably without looping, to replace some characters with another character.
The problem I have run into is that when I use Replace in VBA it is only applied to cells with no more than 1024 characters and so I tried using Substitute but that crashes if there is more than 1271 characters in a cell so I don't know how to process these long strings quickly.
I tried the following and hit the limits mentioned above:
Bookmarks