S
Stephen Mayr
Hi, Celia
To answer your first question, here's the formula you can
use that will make the first char upper case and the rest
lower case
=UPPER(MID(A1,1,1))&LOWER(MID(A1,2,LEN(A1)))
You can subsitute A1 with the cell(s) that need to be
converted.
Let me know if this helps.
To answer your first question, here's the formula you can
use that will make the first char upper case and the rest
lower case
=UPPER(MID(A1,1,1))&LOWER(MID(A1,2,LEN(A1)))
You can subsitute A1 with the cell(s) that need to be
converted.
Let me know if this helps.