Using the Concatenate Function in Excel, you can add a prefix.
Another option for adding a prefix or suffix to a set of cells in Microsoft Excel is to use the "Concatenate" function.
To use the Concatenate function to add the prefix (Dr.), type =Concatenate("Dr. ",A4) and press the enter key on your computer's keyboard.
