CONCATENATE

[jim]

I can concatenate 3 name cell into one, but how do I get
the names into one cell with a space between each name?
Exp cell a, apples cell b, oranges cell c, grape
I get applesorangesgrape
I need apple orange grape
thanks

 

[Beth]

A1 = apple
B1= orange
C1= grape

Then D1 =A1&" "&B1&" "&C1
Or, D1 =CONCATENATE(A1," ",B1," ",C1)

 

[Alan Beban]

The OP's stated data is apples, oranges, grape; not apple, orange, grape.

If those values are in A1, B1 and C1, the following will work so long as
there are no "s"'s except for the final letter of each value (watch for
word wrap in this posting):

=SUBSTITUTE(A1,"s","")&" "&SUBSTITUTE(B1,"s","")
&" "&SUBSTITUTE(C1,"s","")

Alan Beban

 

[jim]

thanks Beth, I was leaving out one of the ampersands.

 

[Myrna Larson]

I have a sneaking suspicion that the OP had a typo when she used singular in her example of
desired result.