...
The steps in the second example below explain how to take 2 columns, such as first and last name columns, and combine them into a full name column.
Step-by-step guide
Example: Combining
...
Student ID and
...
Program Columns into a
...
Colleague Key
- 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(
Example: Combining First and Last Name Columns into a Full Name Column (LastName, FirstName)
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...