Assuming that "apple" "pear" and "orange" are in cells A1, A2 and A3,
respectiively, try =A1&" "&A2&" "&A3

This is a short form of the Concatenate function. Use the ampersand symbol
to "join" two cells together. To get the spaces between the words, join " "
to the cells, as well.

HTH
--
LPS


"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