How to combine text from 3 cells into 1 cell
 

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

How to combine text from 3 cells into 1 cell
 

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?

How to combine text from 3 cells into 1 cell
 

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

or

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

"JOF" wrote:

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

How to combine text from 3 cells into 1 cell
 

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?

How to combine text from 3 cells into 1 cell
 

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