How to convert text to Title Case/Proper Case/CamelCase

[j_w]

For example, how to convert following column values:

Column1

an apple

TWO BIG BARS

into:

Column1

An Apple

Two Big Bars

Thanks

[deldersveld · Accepted solution]

In the Query Editor, go to the Transform tab, select Format, and select Capitalize Each Word.