UPPERCASE to lowercase

**davesexcel** · 01-09-2012, 10:59 PM

=proper(range)
This would have to be used in a separate column
If you want this to be done automatically, VBA would have to be involved.
Attach a sample workbook reflecting what your workbook setup is like, so somebody can assist you.

Darn it!!
Okay, then go with Jeff's solution.

**ericinarcata** · 01-09-2012, 11:15 PM

Thanks. Here is part of the file. Column A is in all caps. Trying not to use another column. Never created a macro or VBA before. Is it pretty simple.

Cheers,

Eric Christian

**jeffreybrown** · 01-09-2012, 11:41 PM

Originally Posted by ericinarcata

Thanks. Here is part of the file. Column A is in all caps. Trying not to use another column. Never created a macro or VBA before. Is it pretty simple.

Hi Eric,

Are you asking another question?

http://www.rondebruin.nl/code.htm

Creating macros are relative to the amount of time they take and are they easy. Well, I have been hanging around this forum for quite some time and I feel pretty comfortable with a macro like this one, but some of the macros these other folks do are simply amazing.