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 which to add the prefix. Eg. We are creating the list in column C.

From the Not Just Numbers blog: Do you ever have those ... I know it is an issue I come across regularly. I may need to prefix all nominal ledger codes with a department reference, say, or maybe add “ ...