How to combine text from 3 cells into 1 cell

[JOF]

How to combine from 3 text-cells into 1 cell with space between them?

 

[John]

See your other post for answer.
John

 

[muddan madhu]

=A1&" "&B1&" "&C1

or

=CONCATENATE(A1," ",B1," ",C1)

 

[xlmate]

try this if your text are in a column A
in B2
=A2&" "&A3&" "&A4

or if your text are in row 2
in D2
=A2&" "&B2&" "&C2

or use the function =CONCATENATE(A2," ", B2," ",C2)
adjust the range to suit yours

Hope this help
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis

 

[mdmackillop]

A VBA solution

Code
-------------------
Sub Joins()
Dim txt as string, cel as range
For Each cel In Selection
txt = txt & cel & " "
cel.ClearContents
Next
Selection(1) = Trim(txt)
End Sub