Concatenation lets you combine cells in Excel 2003. This feature is also an Excel function. When using this function, Excel opens a dialog box to expedite the combination process. After the cells are referenced in the dialog box, the user confirms the concatenation. The function result will display the new cell content. This feature is helpful when you need to combine cells from different sources in your Excel worksheet.
Open Excel 2003 and select a workbook. Click File on the menu bar and select Open. Click a workbook name at the bottom of the File menu. The workbook opens.
Review the opened worksheet. In the next available cell, type an =. Click the Insert Function button on the formula bar. This button looks like an fx. Type Concatenate in the search box. Click OK. The Concatenate function dialog box opens.
Type the first row name in the Text1 field. For example, if you are combining cells A1 and A2, enter A1. Type the second row name in the Text2 field. Click OK. Review the combined information rows 1 and 2.
