Capitalized Words

[Cozmo35]

I have a list of towns and some are in capitalized type. I would like to know if there is a way to change all words except the first letter from upper case to lower case.

 

[SteveO59L]

Have a lookat Proper()

 

[Cozmo35]

I don't understand what that means. I typed "Proper()" into the search field and notheing came up.

 

[devonkrusich]

I use an add on called ASAP Utilities that has a function to solve your problem.

 

[SteveO59L]

If your list of towns is in col A, then in col B1 enter =Proper(a1) and copy down as far as you need

 

[Cozmo35]

Where can I get that add on?

 

[devonkrusich]

www.asap-utilities.com

 

[Cozmo35]

Thanks!