How do I Convert Uppercase to Lowercase?

[KompuKare]

Originally Posted by techyguy717

Thank you, altrenda and everyone else. This saved a lot of time.

I was copying the formula, but was not pasting the formula correctly.
I merely pasted.

After copying the formula I need to:

- Paste Special
- Paste as Formula

No you don't: you fill down CRTL-D (or right, CTRL-R). Alternatively you could copy everything to clipboard, paste into Word, get it to toggle case (Word calls it TitleCase) and paste special the values back in. You'd lose any formulas though. If all the offending UPPERCASE stuff is confined to whole rows or columns you can just copy those though.

If doing this a lot, VBA is the way to go though.

[altrenda]

I am not a VBA guy, but how would you do it that is easier than
Enter the formula in the first cell
Select the cells in the column you want to change
Click Home Fill Down on the ribbon (assuming excel 2010)

[techyguy717]

Thank You,

I haven't been able to correctly line up the names though.

"Child, A, Julia" would become "A, Julia Child".
But I need it to be "Julia, A, Child"

Using this formula.
=RIGHT(A3,LEN(A3)-FIND(" ",A3,1))&" "&LEFT(A3,FIND(" ",A3,1))

I'm not sure how to correct this.

[coreyspeed]

Fomula would be

=LEFT(A3,FIND(" ",A3,1))&" "&RIGHT(A3,LEN(A3)-FIND(" ",A3,1))

[techyguy717]

coreyspeed, I can't get this formula to work.
=LEFT(A3,FIND(" ",A3,1))&" "&RIGHT(A3,LEN(A3)-FIND(" ",A3,1))

I still get this value: Child, A, Julia

When I switch the LEFT and RIGHT. I get this: julia child, A,

I'm trying to get Julia, A, Child.

I'm hoping to use this formula for a few hundred names.

[KompuKare]

This is pretty basic stuff, but anyway here goes:

=RIGHT(A3,LEN(A3)-FIND(",",A3,(FIND(",",A3))+1)-1)&", " & MID(A3,FIND(",",A3)+2,FIND(",",A3,FIND(",",A3,1))-5)&"," &LEFT(A3,FIND(" ",A3,1)-2)

That should do it.