Hi. I'd like to merge the contents of multiple cells, but I also need to do it about 400 times. I don't want to type in the formula that many times. Can I do this quickly in one or two clicks as with the Autosum function?

Here's what I have so far:
In cell J2
=(D2&","&E2&","&F2&","&G2&","&H2)
In cell J3
=(D3&","&E3&","&F3&","&G3&","&H3)
and so on...



Plz help me.

Thx

Hi PSYloco,

Having input the formula into J2, you should be able to simply copy it to all the remaining rows. Since your address referencing in the formula is relative, the row#s should update automatically. The only reason I can think of that it might not is if you have cell J2 formatted as 'Text'. If it is, changing it to 'General' before copying should fix things.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thx, Macro. That was so easy! My problem was that I was trying to highlight the formula and copy rather than simply selecting the cell (J2) and copying that way.

Thx again.