How to eliminate a character/space between 2 single letters using Regex_Replace?

[morioren]

Hello,

I am trying to eliminate a single space or a character between 2 single letters using Regex:

For example: S P SERVICES  or:  S & P SERVICES

How do I get to: SP SERVICES using the Regex_Replace formula?

Thanks!!

[ivoller]

See attached. Regex matches for word characters separated by space OR non word character.

[morioren]

Thanks so much!

I am looking for something that works for ANY space/characters between single letters.

So if i have I B M  or:  SERVICES S P SERVICES

will the same formula eliminate the spaces between those single letters as well to get to:

IBM

SERVICES SP SERVICES

Not sure if it is possible to achieve such thing using Regex..

Thanks again!

[ivoller]

It gets a bit tricky when we don't know how many to cater for AND we have to worry about non-word characters between single characters. The attached will deal with the examples you mentioned. It may be easier to deal with 'char space char' separate form 'char special char' cases

[ivoller · Accepted solution]

I think we can do it with suitable look ahead/behind logic. Something like the attached.

[morioren · Accepted solution]

wow. that works! thank you very much