Replace specific chars in string w/o changing existing font colour

[staggers47]

I need to be able to go through a string and replace various items (not always the same ones).

Most of the time the string is likely to have text of more than one colour, which I must not change.

It would only ever be one char at a time that would need to be replaced.

In the case I have before me, every instance of "{" needs to be replaced with "[".

Likewise, every instance of "}" needs to be replaced with "]" , all without disturbing whatever colour the original chars had.

So that I don't keep pestering people here, is there any way of generalising this so I can just alter the "find" and "replace with" items accordingly.

In other words, I suppose I'm after a char by char version of the normal Replace function, that doesn't change formatting.

As always, help much appreciated.

Staggers.

[Andy Pope]

You can enter the required find/replace text in the 2 array lines.

Please Login or Register  to view this content.

[staggers47]

Wow, that's going straight in the toolkit. Only thing that's gone right so far today.

Thanks very much Andy.

Regards,

Staggers

[staggers47]

Oh dear, it seems my delight was a little premature!

Although it doesn't seem to matter (I've been experimenting) it's a merged cell that contains the strings being checked and altered where necessary.

The problem seems to be with string length. These strings can be very long (up to 600 characters or more) and it seems that, regardless of where the items to be changed are in the string, once the total string length approaches about 300 characters or so it dies, and just leaves the string unchanged (which is a blessing, I suppose).

I'm completely baffled as to what could cause this. I don't know if you have any ideas?

Regards,


Staggers.

[Andy Pope]

Looks like 255 limit is stopping it from working.

[staggers47]

That's what I thought, but because it wasn't 255 exactly I assumed it must be something else. Looks like I'm going to have to break it down into smaller bits first. That'll be fun, moving things around without messing up the formatting.

[staggers47]

And just to add inult to injury, Excel went insane and I couldn't make any buttons work, so I eventaully re-installed Office, and then it was even worse, with everything on all ribbons greyed-out, as if a cell somewhere was in edit mode, which it wasn't.

Then I remembered that I had a 250MB MS update today. So I restored the system back to before the update and it all worked again. Thanks MS.

I still have the above problem, but at least i can work on it now!