check a row ignore blank cells print only those with text
I want to check down a column of cells, some of which may be blank, I want to
gnore the blank ones and print only the contents (in another cell) those with
a number in them.
eg
A B
1 1234
2 1234
3
in the example above I want to ignore A1 & A3 but print the result of A2 to
B1
|