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

F

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
 
F

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
 
J

Jacob Skaria

Use =PROPER(A1)

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

Jacob Skaria

Use =PROPER(A1)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top