Change Case

[CMD]

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.

 

[Kylie]

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)

 

[Peo Sjoblom]

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

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 edit>paste special as values in place
delete column A

or run a macro

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


Regards,

Peo Sjoblom