You can add prefix or suffix to cells in Microsoft Excel using two simple functions/methods
1. The first method is to use the ampersand & operator to concatenate the cell with the desired text as shown below
![](https://4xdimension.net/academy/wp-content/uploads/2023/04/image-300x229.png)
Press the enter key and you have you text successfully concatenated as shown below
![](https://4xdimension.net/academy/wp-content/uploads/2023/04/image-1-300x247.png)
Hover on the cell B2 at the bottom right till the cursor changes to a + sign, drag the cursor to B6 and you will have all names concatenated as shown below.
![](https://4xdimension.net/academy/wp-content/uploads/2023/04/image-2-300x225.png)
2. The second option is to use the concatenate function in Microsoft Excel.
![](https://4xdimension.net/academy/wp-content/uploads/2023/04/image-3-300x196.png)
Press the enter key, hover on the cell till it changes to a plus sign as above and drag to A6 to complete the entire data as shown below;
I hope this short tutorial was helpful.