We can use two functions to add a prefix to multiple (or all ... Where <prefix> is the prefix to be added and <cell number of first cell> is the location of the first cell in the column to ...