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

See your other post for answer.
John
"JOF" wrote in message
...
How to combine from 3 text-cells into 1 cell with space between them?

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

or

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

"JOF" wrote:

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

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









"JOF" wrote:

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

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

--------------------


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62354