CONCATENATE

  • Thread starter Thread starter jim
  • Start date Start date
J

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
 
A1 = apple
B1= orange
C1= grape

Then D1 =A1&" "&B1&" "&C1
Or, D1 =CONCATENATE(A1," ",B1," ",C1)
 
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
 
I have a sneaking suspicion that the OP had a typo when she used singular in her example of
desired result.
 
Back
Top