View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rollo Tomasi Rollo Tomasi is offline
external usenet poster
 
Posts: 1
Default 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