exes on Mac

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

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,