Joining multiple cells into one line.

Ok I know this sounds like an easy one, but it is not (at least for me).
I have multiple cells with text in each cell that I want to join into one cell.
(this is stripped from a prolog database webpage)

this is kind of what I have, if you imagine they are individual cells
A
B
C
D
E
1
2
3
4
5
6
7
Q
W
E
R
T
Y
U

and I want to end up with three cells like this as a result
ABCDE
1234567
QWERTYU

The text may be different lengths, ideally I would select the cells and run a macro or hotkey and have all the cells, in order, in the topmost cell.

Oh I have about 1,300 conditions of this to add up, hence the requirement to find a shortcut.

Daithi

hello there,
thanks for the reply way back when in January.
I have finally had a chance to look at this.
I am a novice about VB but know a little bit.
I tossed this back and forth and learned some more about activecell and rangeselection. But still could not get this to work.
I would appreciate some pointers if possible.

Your question regarding whether or not I need to separate numbers and text, well I do not.
I have a list of cells (about 1,300) with text in them.
They are all text and I just need to select by mouse say ten cells, although it varies and needs to be user decided) and run the macro.
Ideally the macro would just compile, (concatenate) these cells and stick it into the top most cell to the right.
So if I am compiling cells H32 to H42, then the result would be inserted in I32.
I would then go onto H43-H56 or so and have that inserted into I43.
And so on for about 1,300 cells, and about 600 operations of the Macro.
Fun work for me some evening should I get the Macro to work.
Appreciate any help on this.
Thanks.
DW

I think you can boil that down to one line. Easiest to assign to a button but it's still going to be a chore if you can't automate it.

Please Login or Register  to view this content.