Excel question regarding UPPER or LOWER

Expand Post »

New to all this, so if I've done it wrong, tell me!

EXCEL for MAC:

I have a long (3000 names) mailing list stored as data in columns, of course.

In combining lists, some of the address entries are in Caps others in Upper and Lower case.

Is there any command to format existing column content, for example, to ALL CAPS or UPPER case? Or better yet, the content to Title case. Microsoft word offers "Change Case" with a variety of choices. Is there something similar I can't find for Microsoft Excel?

I did find functions for UPPER and LOWER but can't see how to apply them to a column or group of cells.

Changing it one cell at a time is too ugly to even think about.

Thanks to all who take time to consider this.

Similar Threads

win32::ole and excel question in Perl
Password Generator in Visual Basic 4 / 5 / 6
Character counting/usage (was: Need Help with my CODE!! PLEASE HELP....) in C++
Good Luck w/This one: Excel Question VBA/Macro/other in MS Access and FileMaker Pro
Problem with buttons on a site in Site Layout and Usability

birsha

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jun 2007

Permalink

Jun 28th, 2007

Re: Excel question regarding UPPER or LOWER

http://support.microsoft.com/kb/263580

John A

Team Colleague

Reputation Points: 2240

Solved Threads: 338

Vampirical Lurker

Offline

5,055 posts
since Apr 2006

Permalink

Jun 20th, 2009

Re: Excel question regarding UPPER or LOWER

Hi Birsha,

Upper, Lower and Proper are the text converters in Excel, but you have to create a new column, where the results can be stored.

Add a column to the right of the one you have. If you want title case, go to the cell next to the first entry (e.g. if your addresses are in column D, and your first entry in D2, do this in E2). Type in the formula =PROPER(D2), then fill down (you can do this by mouse - yeeuch! - but there's a nice keyboard shortcut to do this).

Hope this helps.

random1970

Last edited by random1970; Jun 20th, 2009 at 6:03 am.

random1970

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Jun 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Mac Software Forum Timeline: Windows Live for MAC (Messenger 7?)

Next Thread in Mac Software Forum Timeline: Plotting software for Mac

DaniWeb Message

Cancel Changes

User Name
Password