use =PROPER(A1) and fill down in the new column
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"RFJ" wrote:

I've got a payroll dump where everything is in caps (eg First Name and
Surname) - about 2000 rows.

To make it easier on the eye I'd like to add new columns so each text cell
is shown as Initial Caps

ie 'BENJAMIN' becomes 'Benjamin'

Can SKS tell me how (if ?) it might be done

TIA


Rob