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
|