UPPERCASE to lowercase

**ericinarcata** · 01-09-2012, 10:36 PM

We have an export that is roughly 3,000 rows. In column A, customer names, export is in ALL CAPS. We want to change from ALL CAPS to normal formatting.

ie:

KAUAI FRESH FARMS to Kauai Fresh Farms
ROBERT TORNELLO to Robert Tornello

We are trying to do this without retyping the data in each cell. Any quick fixes?

Cheers,

Eric Christian

**jeffreybrown** · 01-09-2012, 10:38 PM

Hi Eric,

Did you look at the functions: Upper(), Lower(), and Proper()

**ericinarcata** · 01-09-2012, 10:51 PM

Jeff. Thanks. Yes. We are trying to have the data in the cell from uppercase to proper, without having to pull from another cell.

**jeffreybrown** · 01-09-2012, 10:58 PM

I don't have 2011 MAC, but guessing maybe it has VBA.

Try...

Please Login or Register  to view this content.

**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.

**vlady** · 01-09-2012, 11:04 PM

another vba i think??!

Please Login or Register  to view this content.

Note: Select all first the entries then run macro ... don't know MAC...

**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.