01-26-2010, 11:59 AM
|
|
Administrator
|
|
Join Date: Oct 2009
Posts: 5,409
|
|
Topic 36: Excel Text Concatenation: How to Join Multiple Cell Together?
To use the Excel text concatenation feature
- Open Microsoft Excel 2003 and create the worksheet as shown below:
- Go to cell E1 and type in the word Result, then select the cell E2. We are going to combine cell A2, B2, C2, D2 using the text concatenation function which is the ampersand (&) symbol.
- However, we cannot automatically just combine Dates and Numbers with Text cells. We need to use the TEXT function.
- " Let us focus first on adding the Title, First name and Last Name together. First select cell E2 and type the following formula:
= A2 & " " & B2 & " " & C2
Note: There is a space between the double quotes. This is to ensure that the text in the fields do not combine together without spacing.
|