A1 has BENJAMIN

In B1 enter =PROPER(A1) which returns Benjamin

Double-click on the fill handle of B1 to replicate down.

You could change all at one go with no formulas if you use a macro.

Post back if that would be preferable or see this thread.

http://snipurl.com/1ftqm


Gord Dibben MS Excel MVP

On Mon, 09 Apr 2007 16:14:47 GMT, "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