Change Case
 

I have a spreadsheet that a user entered everything in caps. I need to
change at least 4 columns to titlecase (ie. JANE DOE to Jane Doe). How can I
do this all at once without going to each cell.

If the name was in A2

=PROPER(A2) Changes text to Title Case (Jane Doe)

or
=UPPER(A2) Changes text to all UPPERCASE (JANE DOE)
=LOWER(A2) Changes text to all lowercase (jane doe)


"CMD" wrote:

I have a spreadsheet that a user entered everything in caps. I need to
change at least 4 columns to titlecase (ie. JANE DOE to Jane Doe). How can I
do this all at once without going to each cell.

You could use 4 help column and the proper function,
assume A1:D200 holds the uppercase, then you can insert 4 adjacent columns
(select columns E:H and do insertcolumn)

Now in E1 put

=PROPER(A1)

copy across to H1 using the fillhandle, then copy down as long as needed,
while still selected do dopy and editpaste special as values in place
delete column A:D

or run a macro

http://www.mvps.org/dmcritchie/excel/proper.htm


Regards,

Peo Sjoblom

"CMD" wrote:

I have a spreadsheet that a user entered everything in caps. I need to
change at least 4 columns to titlecase (ie. JANE DOE to Jane Doe). How can I
do this all at once without going to each cell.