In excel can you change words from all caps to initial caps?

[O2bardy]

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

 

[Bob I]

Use PROPER(ref)

 

[Bob I]

Use PROPER(ref)

 

[Gary''s Student]

=PROPER(A1)

 

[Gary''s Student]

=PROPER(A1)

 

[FSt1]

hi
assuming JOHNEY WALKER is in A2.
=proper(A2)

you can then copy the formula and paste special values in A2.
or if you have a column of names to converte, you might add a helper column
next to your name column. copy the formula down. then copy and paste special
values on the helper column - delete the original column.

regards

 

[FSt1]

hi
assuming JOHNEY WALKER is in A2.
=proper(A2)

you can then copy the formula and paste special values in A2.
or if you have a column of names to converte, you might add a helper column
next to your name column. copy the formula down. then copy and paste special
values on the helper column - delete the original column.

regards

 

[Jacob Skaria]

Use =PROPER(A1)

Also just for information sake
=UPPER(A1) to convert to Upper Case
= LOWER(A1) to convert to Lower Case

 

[Jacob Skaria]

Use =PROPER(A1)

Also just for information sake
=UPPER(A1) to convert to Upper Case
= LOWER(A1) to convert to Lower Case

 

[wmca1932]

example instead of JOHNNY WALKER
I want it to be Johnny Walker.

 

[John]

Hi
You can use =Proper(A1)
HTH
John