Remove all 2 character "words" in a cell

[taxhead]

Hi,

tried already several ideas but my knowledge with Regex_Replace is limited.

I have a dataset with various columns. The "Name" column includes e.g. the full name of a bank (e.g. Branch of the Bank of Russia). I want to remove all this 2 character words (in this case "of"). Additionally, my data consists of a lot of cyrillic entries which makes it even more complicated. I don't know how to created the Regex_Replace formula or is there an other way for this problem?

Thanks in advance 

[MarqueeCrew · Accepted solution]

@taxhead ,

REGEX_Replace([Field1], "\b\w\w\b", '')

This formula will do it all for you.  

Replace what is a word boundary followed by 2 word  [A-Za-z0-9_]  characters followed by a word boundary with nothing.

If you want any character use "\b..\b"  it will include non-latin.

BTW:  

[^\u0000-\u007F]+

That is all non-Latin characters.

Cheers,

Mark

[taxhead]

Thanks, this worked very well!