Copy cell from a coloumn if value is starting with

Question

This question already has an answer here:

Fill non-contiguous blank cells with the value from the cell above the first blank (1 answer)

Closed 4 years ago.

looking for some help...

the below is an example excel table. i have tried to work with alternatives... but none work for me... so again i came back to excel :(

i need : i am looking for a formula or a way to do the below job

i want to copy the cell starting with 0 in B to A

MY TABLE

      A           B            C        D         E
1               0568695
2               956568
3               54649845
4               09447895
5               45649845
6               789454
7               546465465
8               0965445  
9               456465465
10              454478

I NEED

      A           B            C        D         E
1   0568695     0568695
2               956568
3               54649845
4   09447895    09447895
5               45649845
6               789454
7               546465465
8   0965445     0965445  
9               456465465
10              454478

UPDATE :

is it possible to copy the value in A till next Empty cell

      A           B            C        D         E
1   0568695     0568695
2   0568695     956568
3   0568695     54649845
4   09447895    09447895
5   09447895    45649845
6   09447895    789454
7   09447895    546465465
8   0965445     0965445  
9   0965445     456465465
10  0965445    454478

Answer 1

You can use the formula:

=IF(LEFT(B2,1)="0",B2,A1)

And drag the formula down to the bottom.

Note: You will have to evaluate A1 manually.

Answer 2

Try this:

=IF(LEFT(B1, 1)="0",B1,"")

Hope this helps,
kpark.