I'm getting a list of names and it is formatted last name, first name all in caps. Dose any one know of an easer way you convert this list correctly (first name, last name with the proper caps) with out typing all the names again?
If you can import the list in Excel or if you already have it in Excel, use the formulae "Proper" "Upper" "Lower". So for example if you have "JOHN DOE" in cell A2 and you want to convert it to proper case which is "John Doe", then type in this in an empty cell "= Proper(A2)" and that cell will convert the name into Proper Case.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.