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.