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

  • Thread starter Thread starter O2bardy
  • Start date Start date
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
 
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
 
Use =PROPER(A1)

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

Also just for information sake
=UPPER(A1) to convert to Upper Case
= LOWER(A1) to convert to Lower Case
 
You must log in or register to reply here.

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

Similar Threads

Music: One song that always cheers me up! 4
Change all text on Spread sheet 1
change to all caps 4
How do you change the Capitalization in an Excel Workbook? 7
All Caps 2
CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING 3
hOW DO i TURN TEXT INTO ALL CAPS? 2
Transforming many cells of all caps into first letter capitals onl 5

Back
Top