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.
![Add Prefix in Excel Using Concatenate Function](https://www.techbout.com/wp-content/uploads/2018/09/add-prefix-using-concatenate-function-excel.png)