One Last question!

Yadlik · May 20th, 2002, 02:39 PM

One last question for the group (for today anyway). Is there any easy way to merge cell contents? My spreadsheet now has one word per cell. I need to combine multiple cells in a row to form a sentence in a single cell.

Von Pookie · May 20th, 2002, 02:45 PM

If your words are in A1:A4, just use this:

=CONCATENATE(A1," ",A2," ",A3," ",A4)

Just change the cell references to what you need.

Hope it helps!

_________________
~*Kristy*~

"Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam."

[ This Message was edited by: Von Pookie on 2002-05-20 13:47 ]

Yadlik · May 20th, 2002, 02:50 PM

Thanks!

Yogi Anand · May 20th, 2002, 02:51 PM

or just

=A1&" "&A2&" "&A3&" "&A4

May 20th, 2002, 02:51 PM	#4
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	or just =A1&" "&A2&" "&A3&" "&A4 __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 02:39 PM	#1
Yadlik New Member Join Date: May 2002 Posts: 34	One last question for the group (for today anyway). Is there any easy way to merge cell contents? My spreadsheet now has one word per cell. I need to combine multiple cells in a row to form a sentence in a single cell.

May 20th, 2002, 02:45 PM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	If your words are in A1:A4, just use this: =CONCATENATE(A1," ",A2," ",A3," ",A4) Just change the cell references to what you need. Hope it helps! _________________ ~Kristy~ "Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam." [ This Message was edited by: Von Pookie on 2002-05-20 13:47 ]

May 20th, 2002, 02:50 PM	#3
Yadlik New Member Join Date: May 2002 Posts: 34	Thanks!