Prefixes and suffixes are additions to words that change them into different words. Prefixes are added to the beginning and suffixes are added to the end of the word. Examples of a prefix include ...

The numbers contain no meaning beyond that. In the example above, 11360 is the CRN for this course and section. The four-letter Course Prefix indicates the department or program offering the course.

We can use two functions to add a prefix to multiple (or all) entries across a column. The first one is using the & operator, and the second is using the CONCATENATE function. Where <prefix> is ...