Upper. Text: The text that you want to convert to uppercase. It is required. In this tutorial, we will explain how to use the Lower function to convert text into lowercase and the Upper function ...

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