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
|