If you have a column with capitalized text and you want to convert it to lowercase but with the first letter capitalized try the following code to a new column:
|
1 |
CONCATENATE(UPPER(LEFT(C2;1)) ;LOWER(RIGHT(C2;LEN(C2)-1))) |
If you have a column with capitalized text and you want to convert it to lowercase but with the first letter capitalized try the following code to a new column:
|
1 |
CONCATENATE(UPPER(LEFT(C2;1)) ;LOWER(RIGHT(C2;LEN(C2)-1))) |