The Concatenate function, or CONCAT in more recent versions of Excel, is used to join two or more text strings into one string.
The steps in the first example below would help an academic advisor to use two columns from a report about advisees to join the student ID number and the academic program to create a column with the Key needed in Colleague to run a process such as BEVL: Batch Academic Evaluation and generate one PDF with all advisees' degree audits.
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 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(
Example: Combining First and Last Name Columns into a Full Name Column (LastName, FirstName)
Related articles
For additional assistance, contact the IT Help Desk.