exes on Mac

Occasional Visitor

how to I format column of names to capital first letter, lowercase remaining letters?

1 Reply

@staceysuebaler1675 

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

mathetes_0-1669778208183.png

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,