Hi everyone.

This is how my Column A looks like:

A1: abc
A2: 0
A3: 0
A4: 0
A5: xyz
A6: 0
A7: 0
A8: dfg
A9: 0

I would like to have a formula, preferably in column B, that replaces 0s so that the final result is as follows:

A1: abc
A2: abc
A3: abc
A4: abc
A5: xyz
A6: xyz
A7: xyz
A8: dfg
A9: dfg

Any help much appreciated.