The Concatenate function, or CONCAT in more recent versions of Excel, is used to join two or more text strings into one string.
The scenario steps in this example: The following steps 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.
Step-by-step guide
There are two examples below: 1) Creating a Key column for use in Colleague and 2) Creating a full name column from separate 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)
...