filling empty cell if not empty keep its content!?

[Tarek]

Can you please help?

Issue: i have a column and I am trying to fill empty cells with numbe
zero, however if the the cell already filled with a number to keep th
same number: I tried the following formula wich failed:
IF(A2="",0,A2)

I tried adding iserror and I also wasn't successful, any help is wel
appreciated.

Thanks,
Tare

 

[Norman Harker]

Hi Tarek!

You need to create an interim helper column first.

Insert a column
In that column use the formula (eg for first cell is A1)
=IF(A1="",0,A1)
Copy down

Now select the new column
Copy
Edit > Paste Special > Values > OK

You can now delete the original column

Instructions vary only slightly if you don't want to change all
contents of a particular column.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
are you trying to apply this formula in the same column. that is are
you entering your formula from below in cell A2. If yes this won't
work. But you may try one of the following:
1. Use a helper column B. Enter your formula from below in B2 and copy
down. After this you can copy column B and insert it as values above
column A ('goto 'Edit - Paste Special' and choose 'Values')

2. Another way:
- select all of your cells in column A
- Hit F5
- click 'Special'
- choose 'Empty cells'
- enter '0' and hit CTRL+ENTER (this will fill a '0' in all empty cells

 

[Harlan Grove]

2. Another way:
- select all of your cells in column A
- Hit F5
- click 'Special'
- choose 'Empty cells'
- enter '0' and hit CTRL+ENTER (this will fill a '0' in all empty cells

....

They're 'Blank' cells, not 'Empty' cells, in English language versions.

 

[Frank Kabel]

They're 'Blank' cells, not 'Empty' cells, in English language
versions.

Thanks Harlan for the correction