=upper(left(a2,1))&lower(right(a2,len(a2)-1)) This formula works in two parts. First, it converts the first letter of the ...

How to change between upper, lower, and capitalization using Transformations Highlight the text you want to modify the capitalization of. In the toolbar, click on Edit .