Browse » Home
Tuesday, January 15, 2013
How to Merge a Last Name and First Name in Excel 2007
1. Launch Microsoft Excel. Locate the spreadsheet that contains your name information and open the file.
2. Click in the first cell of an empty column beyond the spreadsheet area that contains your data. Click 'Insert Function' from the 'Function Library' group of the 'Formulas' command tab and choose 'Text' from the list in the dialog box.
3. Select 'Concatenate' from the 'Select a function' list and click on the 'OK' button. Click in the 'Text1' box in the dialog box and enter the ID of the cell that contains the part of the name--last or first--that you want to be the first part of your concatenated text. To choose the cell by clicking on it instead of entering its ID, click on the 'Collapse Dialog' button. It looks like a set of spreadsheet cells with a small red arrow pointing up toward the top left corner of the button. Once the dialog box is out of your way, click on the cell that contains your desired data, then click on the 'Restore Dialog' button. This button has a small red arrow pointing down from a box that represents a cell boundary.
4. Type a double quote mark into the 'Text2' box, followed by any text you want to appear between the two parts of the name, then another double quote mark. If you're combining last name first, then first name, you'll want a comma and a space between the names, so you'll type ', ' in the 'Text2' box. If you're combining first and last names in that order, you'll only need a space between them, so just type ' ' in the 'Text2' box.
5. Type the ID of the cell that contains the second part of the name into the 'Text3' box in the 'Function Arguments' dialog box. The ID consists of a reference to the cell by its column letter and row number. To choose by clicking on the cell that contains your data, click the 'Collapse Dialog' button next to the text field, click on the data cell, then click the 'Restore Dialog' button.
6. Click on the 'OK' button when you have finished entering or selecting all your data and cell IDs. Your concatenated text now shows in the cell, while the 'Formula Bar' at the top of your document shows the formula you constructed in the 'Function Arguments' dialog box.
7. Propagate your formula down the column of cells by placing your pointing device at the bottom-right corner of the cell in which you entered your formula and dragging down till you reach the end of your data. When you release the pointing device, you'll see your formula applied throughout the column, with the cell references updated to use the data from each row.