Thread: [Solved] Concatenate/merge contents of multiple cells
View Single Post
 
Old 05-14-2011, 03:33 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote