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,