...
- In Microsoft Excel, select a column for entering the new information.
- Click on an empty cell at the top of the column.
- Type the following formula:
- =CONCATENATE(A2,"*",B2)
- If you are combining contents from other columns instead, use their labels.
- Excel help text appears as you type to remind you of the next step in the formula.
- A comma separates each component of the formula.
- In this example, typing "*" between A2 and B2 inserts an asterisk between the ID and the program. This is important in Colleague keys. The key won't work without the asterisk.
- Press enter, and the formula will be replaced with the results as shown below.
- Click on the cell and "drag" the formula from the top cell down to the bottom of your list. Hint: double-clicking on the cell's bottom-right corner will quickly populate the whole column and stop where the text in the adjacent column stops.
Example: Combining First and Last Name Columns into a Full Name Column (LastName, FirstName)
...