TexasCHLforum.com

You can also use the =CONCATENATE function in Excel
CONCATENATE(text1,text2,...)
Argument
Description
text1,text2,...
1 to 255 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
General remarks
The "&" operator can be used instead of CONCATENATE to join text items.
Example
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

1
2
3
4
A B
Data
brook trout
species
32
Formula Description (Result)
=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile") Concatenates a sentence from the data above (Stream population for brook trout species is 32/mile)