It sounds like you need to use the Concatenate function.

Try this in cell C3
=CONCATENATE(A1," ",A2," ",A3)

Good luck!
SME

FIRSTROUNDKO via OfficeKB.com wrote:
Hi!

Please can somebody show me how to string together this?

apple fruit
pear fruit
orange fruit

potato veg

pear fruit
plum furit

To become this

apple fruit
pear fruit
orange fruit apple pear orange

potato veg potato

pear fruit
plum furit pear plum

Thanks in advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1