Field Character Changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ronald_L - 31 Jan 2005 16:05 GMT

I have a row of approx 3000 names that are in all uppercase. The are in the
format of FirstName LastName. How can I set a formula to leave only the
first character of the first and last name in uppercase and the rest
lowercase. Such as John Doe instead of JOHN DOE.

Reply to this Message

Paul B - 31 Jan 2005 16:23 GMT

Ronald, use the proper function, like this, =PROPER(A1) than you can copy
and paste special valves back over you data

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

>I have a row of approx 3000 names that are in all uppercase. The are in
>the
> format of FirstName LastName. How can I set a formula to leave only the
> first character of the first and last name in uppercase and the rest
> lowercase. Such as John Doe instead of JOHN DOE.

Reply to this Message

Gord Dibben - 31 Jan 2005 18:59 GMT

Ronald

Note on PROPER() Function.

If you have names with Mc or Mac or like van der Meer PROPER() won't do the
trick.

You will wind up with Mcdonald or Van Der Meer.

David McRitchie has VBA code that will look after many of these.

http://www.mvps.org/dmcritchie/excel/proper.htm

Gord Dibben Excel MVP

>Ronald, use the proper function, like this, =PROPER(A1) than you can copy
>and paste special valves back over you data

Reply to this Message