Try the function Proper (text) in the next column over where text is your all capital words. Then copy this formula all the way down the column. Now copy the formula column and paste special just the values right on top of the formula column or in another column. You should get what you want...
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.