Concatenate/merge contents of multiple cells

		Microsoft Office Forums > Microsoft Excel > Excel
Concatenate/merge contents of multiple cells

FAQ

Thread Tools

Display Modes

05-14-2011, 03:05 PM

PSYloco

Windows XP Concatenate/merge contents of multiple cells

Office 2003

Novice

Join Date: May 2011

Posts: 2

Concatenate/merge contents of multiple cells

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

Tags

concatenate, merge, merge contents

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple VLOOKUP's checking multiple Cells	OTPM	Excel	11	05-23-2011 11:18 AM
filling multiple cells whislt using Filter	VinceO	Excel	1	05-09-2011 06:38 AM
Multiple tables of contents	pedroftramos	Word	2	08-11-2010 05:48 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
How to transfer multiple cells from excel to word by formulas	justziggy	Word	5	05-23-2009 02:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:36 PM.