We can use two functions to add a prefix ... 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 ...