Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Add Prefix or Suffix Batches in Microsoft Excel

Date:2021-6-30 Author:Sandra

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 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

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

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

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

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~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *