Combine Text from Multiple Cells

[Carter]

How do I combine text from mutliple cells into one cell?

 

[JulieD]

Hi Carter

one option - well two really:

if the information is in cells A1, B1 & C1 and you want it combined into D1
then in D1 type
=A1 & " " & B1 & " " & C1
this will give you the contents of each with a space between
OR
=CONCATENATE(A1," ",B1," ",C1)
which will give you exactly the same thing

Hope this helps
Cheers
JulieD

 

[jws217]

there are two ways I know of

1. "=A2&B4"
2. "=CONCATENATE(A2,B4)

 

[Carter]

Thanks for your help.

-----Original Message-----
CONCATENATE: Joins several text strings into one text string.

A
---------
1 Data
2 brook trout
3 species
4 32

Syntax: CONCATENATE (text1,text2,...)
Example: =CONCATENATE("Stream population

for ",A2," ",A3," is ",A4,"/mile")