If you need to add the same prefix and suffix to many cells, would you choose to add them one by one? This will definitely add to your workload. So today I want to share with you guys an easy skill for auto-adding prefixes/Suffix or changing prefixes/Suffix to existing text.
Method 1:
Highlight the cells you need to add prefix or suffix and press Ctrl + 1 to quickly get Format cells Window.
Go to Number and choose Custom. Type K in Infront of General and hit OK.
![How to Add Prefix or Suffix Batches in Microsoft Excel How to Add Prefix or Suffix Batches in Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/06/image-72.png)
![How to Add Prefix or Suffix Batches in Microsoft Excel How to Add Prefix or Suffix Batches in Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/06/image-73.png)
This only changes the format of the cells, but does not enter the actual content.
Method 2:
Type =”T”& in Cell C7 and click on cell A7, then press Enter key.
![How to Add Prefix or Suffix Batches in Microsoft Excel How to Add Prefix or Suffix Batches in Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/06/image-74.png)
You can quickly get the T1022462 in Cell C7.then drop down to fill it.
![How to Add Prefix or Suffix Batches in Microsoft Excel How to Add Prefix or Suffix Batches in Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/06/image-75.png)
The same goes for adding suffixes.
![How to Add Prefix or Suffix Batches in Microsoft Excel How to Add Prefix or Suffix Batches in Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/06/image-76.png)
![How to Add Prefix or Suffix Batches in Microsoft Excel How to Add Prefix or Suffix Batches in Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/06/image-77.png)
This method is essentially a formula to combine the content you want to add with the original content into a new cell.
Personally, I prefer the second option. That’s all for today’s tutorial. See you next time~
Hi there,
your prefix and surfix instructions are great help to me!
May I know if it is possible to insert a spacing for such command?
For example instead of K12345, I need it to be K 12345.
Thanks!!!
Best regards,
Jeremy