MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help combining cells till blank


Posted by Gibo on January 31, 2002 5:32 AM

Hello all,

I am having a problem with a little project I am working on. I have a single Column i.e.

text_string_here
text_string_here (these 3 need to be one cell)
text_string_here

text_string_here (these 2 need to be one cell)
text_string_here

text_string_here
text_string_here
text_string_here


what I need is a Command / macro that would look down the list until a blank cell is found and CONCATENATE the contents into a single cell then start the next group of cells.

I think that should be clear enough. Sorry for being so thick but I am new to this kind of stuff...

Thanks in advance and kind regards

Gibo


Posted by Chris D on January 31, 2002 2:45 PM

Hey Gibo,

do you mean that you want the existing column to be merged or do you want the three text strings concatenated in a different column ?

You could probably achieve either by recording a macro and being very very careful switching between absolute and relative modes, but I imagine the VBA experts could come up with a dog's b*ll*cks solution that is much quicker and more elegant

HTH
Chris