How to upper case first letters but not in case of articles (the, by, of, etc.)

[FabioP]

Hello everyone!

Is it possible to upper case first letter of words but change (or keep) articles as lower case?

I'd like to know the which is the best way to transform the example below:

From	To
CONCERT BY JOHN WINE	Concert by John Wine
LUCCA THE WHITE SNAKE	Lucca the White Snake

and

From	To
jordan son of the king	Jordan Son of the King
jade brown a big star	Jade Brown a Big Star

Many Thanks!

[flying008]

Hi, @FabioP 

A formula for you :

TitleCase([From])

******

If can help you get your want, please mark it as a solution and give a like for more share.

[caltang · Accepted solution]

@FabioP I've done something similar to @flying008 but with a bit more controls and takes into account the common words like "a", "the", "of", etc.

[flying008 · Accepted solution]

Hi, @FabioP  @caltang 

I'm fix the formula now, maybe you can try it again:

REGEX_Replace(TitleCase([From]), '(?<=\s)(a|an|by|of|the)(?=\s)', '\L$1')

[caltang]

Very cool man!

[FabioP]

Thank you Guys! (@caltang and @flying008)

It helped a lot...