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:33 PM

macropod

Windows 7 32bit Concatenate/merge contents of multiple cells

Office 2007

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,526

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]

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 09:11 AM.