Hi,

I have a large spreadsheet that had billing information dumped into it. The descriptions for each billing line item range from 1 cell to 10 cells (in columns). Example below:

G4: Telephone conference with X. XXXXX re status
G5: re change orders and possible mechanics'
G6: lien; telephone conference with X. XXXXX re
G7: status and strategy re change orders

...and so on. Between each block of text there is an empty cell. I am hoping someone would be able to supply me with help or a macro to create a single block of text for each entry, perhaps utilizing the fact that there is an empty cell before and after each block of cells containing the text I wish to concatenate.

Any ideas?

Thanks,

Alex