Changing Caps in the last name

[HEMPHIL4]

Good Morning!

I have a bunch of names and they all are basic like so:

Steve Smith
John Doe
Smith Smith

I need these names to all have lowercase last names so:

Steve smith
John doe
Smith smith

lol ik its weird but its a requirement and there are like thousands of these names. Please HELP!!!!!!

[amotto11]

try this assuming your data is in column A

Please Login or Register  to view this content.

*edit, this will only work with one last name people. If they have a space in their last name for some reason, it will not catch the full name.

[turtle054]

You could use the Text to Columns feature to separate the names into two columns, use the =LOWER formula to convert the last names to lowercase, then use a formula like =CONCATENATE(A1," ",B1) to join the names with a space.

[HEMPHIL4]

These ideas both worked for me thank you!