The first one is using the & operator, and the second is using the CONCATENATE function. Where <prefix> is the prefix to be added and <cell number of first cell> is the location of the first cell ...