Nov 29 2022 05:00 PM
how to I format column of names to capital first letter, lowercase remaining letters?
Nov 29 2022 07:19 PM
how to I format column of names to capital first letter, lowercase remaining letters?
That's achieved not via format per se, but via a function: PROPER
The formula in cell B1 has turned the "stacy sue" from A1 into "Stacey Sue"
For a whole column, just copy the formula down. If you want to convert the original cell, you can do a Copy....Paste Special and select Paste Special...and then "Values" and paste the "corrected" names over the original,