How to find/replace data in column
 

Hi,

In Excel I have a column of 0's as text and I want to change the whole
column to 1 but still as text.

How can I do this?

I tried a find/replace, but the 1 was entered as a number not as text.

Thanks
Rock

How to find/replace data in column
 

Thank you Gord...

The column I wish to change is actually K.

Does this mean the A1 in the formula should in fact be K1 ?

Rock


Gord Dibben wrote:
Rock

In an adjacent column.

=IF(A1="0",TEXT(A1,"1"))

Drag/copy down.


Gord Dibben Excel MVP


On Wed, 16 Nov 2005 08:26:57 +1100, Rock wrote:


Hi,

In Excel I have a column of 0's as text and I want to change the whole
column to 1 but still as text.

How can I do this?

I tried a find/replace, but the 1 was entered as a number not as text.

Thanks
Rock

How to find/replace data in column
 

Rock

In an adjacent column.

=IF(A1="0",TEXT(A1,"1"))

Drag/copy down.


Gord Dibben Excel MVP


On Wed, 16 Nov 2005 08:26:57 +1100, Rock wrote:

Hi,

In Excel I have a column of 0's as text and I want to change the whole
column to 1 but still as text.

How can I do this?

I tried a find/replace, but the 1 was entered as a number not as text.

Thanks
Rock

How to find/replace data in column
 

Yes.

Change A1 to K1


Gord

On Wed, 16 Nov 2005 08:53:06 +1100, Rock wrote:


Thank you Gord...

The column I wish to change is actually K.

Does this mean the A1 in the formula should in fact be K1 ?

Rock


Gord Dibben wrote:
Rock

In an adjacent column.

=IF(A1="0",TEXT(A1,"1"))

Drag/copy down.


Gord Dibben Excel MVP


On Wed, 16 Nov 2005 08:26:57 +1100, Rock wrote:


Hi,

In Excel I have a column of 0's as text and I want to change the whole
column to 1 but still as text.

How can I do this?

I tried a find/replace, but the 1 was entered as a number not as text.

Thanks
Rock

How to find/replace data in column
 

Also see Dave Peterson's answer to your other post in microsoft.public.excel
for an alternative.


Gord

On Tue, 15 Nov 2005 14:38:17 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Yes.

Change A1 to K1


Gord

On Wed, 16 Nov 2005 08:53:06 +1100, Rock wrote:


Thank you Gord...

The column I wish to change is actually K.

Does this mean the A1 in the formula should in fact be K1 ?

Rock


Gord Dibben wrote:
Rock

In an adjacent column.

=IF(A1="0",TEXT(A1,"1"))

Drag/copy down.


Gord Dibben Excel MVP


On Wed, 16 Nov 2005 08:26:57 +1100, Rock wrote:


Hi,

In Excel I have a column of 0's as text and I want to change the whole
column to 1 but still as text.

How can I do this?

I tried a find/replace, but the 1 was entered as a number not as text.

Thanks
Rock