combine text in different cells

[Mads]

I have text in 5 different cells (one word in each), how do I combine all
the text in the 5 cells into one cell with a function?

I appeciate any suggstions.

Mads

[Peo Sjoblom]

One way,

=A1&" "&A2&" "A3&" "&A4&" "&A5

I assumed you wanted a space between each word

also look at the concatenate function

=CONCATENATE(A1," ",A2) and so on

--

Regards,

Peo Sjoblom

"Mads" <mad-bj...@online.no> wrote in message
news:A6p8a.33516$Rc7.4...@news2.e.nsc.no...

[Lloyd]

Concatination is what you need.

Assume the cells a1,b1,c1,d1,e1 have the data.

Concatinate into cell f1.

Use the formula =Trim(a1 & " " & b1& " " & c1& " " &
d1& " " & e1)

When finished you may want to Copy and Paste, Special,
Value into F1.

>.
>

[H.Hoang]

Use function CONCATENATE()

Cheers

"Mads" <mad-bj...@online.no> wrote in message
news:A6p8a.33516$Rc7.4...@news2.e.nsc.no...

[TKT-Tang]

GGVT Re - Combine text in different cells

1. I would like to attempt a practical exercise (on an Excel
workSheet) as follows :-

2. Enter Text Strings (e.g., One, Two, Three, Four and Five) into a
contiguous Range of Cells such as A1:A5.

3. Enter a Formula into the Cell B1: =A1 ; It shows "One".

4. Enter another Formula into the Cell B2:

5. =CONCATENATE(B1,CHAR(10),A2)

6. While the Active Cell is located at B2, Select the Menu Item,
Format > Cells > Alignment > Wrap Text (to be Ticked) > OK (to return
to the WorkSheet).

7. See that the Cell B2 display "One" stacked atop "Two".

8. Fill-Down with the Formula from the Cell B2 to B5 ; Format the Cell
B5 as in Step 6.

9. See that the Cell B5 display the given Text Strings stacked atop of
one another.

10. Note that if the Cell B5 is not Wrap-Text-Formatted, it would
display the Concatenated Text Strings interspersed with Small Squares
(namely, as a result of the Function CHAR(10) included with the
Formula) between the individual Text Strings.

11. Right-Click the Cell B5, Select Copy from the accompanying
Short-Cut Menu > Right-Click another Blank Cell say, B6 > Paste
Special > Values > OK.

12. See that the Cell B6 display the given Text Strings by virtue of
the listed steps of operations.

13. Should an elongated Concatenation be required, make use of the
following Formula,

14. =CONCATENATE(B1," ",A2) ; it will leave a blank space between the
individual Text Strings Concatenated.

15. Regards.