CONCATENATE

is a formula used to link information together. This is useful in combining data from separate columns and including specific syntax in order to create the fullname or shortname. 


» Excel Functions for Reformatting Data Files (CSV)