I am trying to select from a column of 30-40 cells (cells that are not blank)
and combine them into one cell. I am using concatenate but formula will be
too long.


Eg of my formula
=CONCATENATE(G2,"",G3,"",G4,"",G5,"",G6,"",G7,"",. .. G30)

Thanks

--
Siva