changing names to lower case, but keeping first letters capitalized

**hyattj** · 06-17-2014, 04:04 PM

I am looking to change a huge list of names that are all capitalized to lower case but want to keep the first letter of the first and last name capitalized..........ex. "DANA A CZMER" --> to "Dana A Czmer" . I started with chaning all to lower case and then break the names into strings to uppercase the first letters but am struggling. Does anyone have suggestions/

-Jake

**XOR LX** · 06-17-2014, 04:15 PM

Hi,

From your one example, I would be tempted to conclude that all strings to be considered consist of precisely one first name, one middle initial and one surname.

If this is not the case, could you give enough examples such that comprehensively represent all variations in your data, together with your desired results?

Regards

**AranDG** · 06-17-2014, 04:18 PM

The PROPER function will solve this, assuming your name is in cell A1

Please Login or Register  to view this content.

**protonLeah** · 06-17-2014, 04:18 PM

Use a helper column with =PROPER(A1), then use Copy, paste special, values to replace the old list.

**hyattj** · 06-17-2014, 04:49 PM

The proper function worked perfectly, thank you for the help

changing names to lower case, but keeping first letters capitalized

LinkBack

Thread Tools

Rate This Thread

Display

changing names to lower case, but keeping first letters capitalized

Re: changing names to lower case, but keeping first letters capitalized

Re: changing names to lower case, but keeping first letters capitalized

Re: changing names to lower case, but keeping first letters capitalized

Re: changing names to lower case, but keeping first letters capitalized

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] calculateing how many higher case letters in a row and how many lower case letters

Add characters between lower case and upper case letters

[SOLVED] Mass changing upper case to lower case letters

Change lower case letters to upper case

[SOLVED] Capital letters in names written by lower case

Bookmarks

Bookmarks

Posting Permissions