You need to add a group of letters to the end of a word to make a new word. For example, if the suffix ‘ing’ is added to the end of the word ‘look’, the new word is ‘looking’ - or the ...

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 ...