...
Example: Combining First and Last Name Columns into a Full Name Column (LastName, FirstName)
- 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(B2,", ",A2)
- By entering B2 before A2, you can choose LastName, FirstName formatting for your column. If you prefer FirstName LastName instead, type "=CONCATENATE(A2," ",B2). Entering " " adds the space between the names.
- 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 B2 and A2 inserts a comma and space between the last name and first name.
- 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.
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...