I found a post that explained how to add text to the end of a group of cells.
I have a list of names starting in B4. The text I want to add to the beginning of each cell is in cell C3. If I use the formula below, it adds the text to the end of each cell.
=C3 & " " & $A$1
How do I change this formula to make it add the text to the beginning of each cell?
Bookmarks