Excel Novice thrown in at the deep end

**relaxitscool** · 01-22-2013, 07:37 AM

As the title says I'm not an expert on excel, by any stretch but have a large worksheet with cells I need to merge so I can cut and paste the merged cells into a word template.

I've done some searching on the net and have used - =A3&" "&B3&" "&C3&" "&D3&" "&E3&" "&F3&" "&G3 to merge the row into column H. The problem is I have 4300 rows. Is there a way of doing this using a formula or macro, or should I settle on doing it 4300 times!!

Many thanks

Rob

**dilipandey** · 01-22-2013, 07:44 AM

HI rob,

welcome to the forum.
Suggest you to change the thread title to reflect the query you are asking... see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey
<click on below * if this helps>

**RHCPgergo** · 01-22-2013, 07:46 AM

Making that formula was the hard part.

Now just drag cell H3 at the bottom right corner and pull down to H4300. The rows in your formula will change to the actual row.

**relaxitscool** · 01-22-2013, 08:53 AM

Done!!!! Thank you so very much

**arlu1201** · 01-22-2013, 09:07 AM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

You were advised to edit the title for this thread, however since you created a new thread for the same topic, this has been flagged as duplicate.

Thread Closed.