Reformatting text in cells
 

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

Reformatting text in cells
 

=PROPER(A1)

where A1 is the cell whose text you want to convert to initial caps.

cheers,
..o.

On Apr 9, 9:14 am, "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

Reformatting text in cells
 

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

Reformatting text in cells
 

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