Sourav Kundu
There are many ways to add suffix in Excel. Out of those many ways, we will show you 2 easy ways to add suffix in Excel without formula. Isn’t it the best part that you don’t have to use any formula to follow these methods? Definitely! Hope you are going to like the article.
Download Practice Workbook
You can download and practice from this workbook.
2 Ways to add Suffix Without Formula in Excel
Excel provides us with many features to ease our tasks. From the verse features, we will use Custom Format Text and Flash Fill features to add suffixes in Excel.
1. Using Custom Format Text Feature to Add Suffix
1.1. Custom Format for Weight
This is our dataset consisting of weight values. We will add their unit value Kg as a suffix.
➤ First, copy all the values of Column B in column C and select C5:C10.
➤ Then press CTRL+1 and the Format Cells window will open.
➤ Write the following Text in the Type box and press OK.
Thus, we get all the weight values suffixed with Kg.
1.2. Custom Format for Length
We have taken a dataset for Length. We will add their unit value cm as a suffix.
➤ First, copy all the values of Column B in column C and select C5:C10.
➤ Then press CTRL+1 and the Format Cells window will open.
➤ Now, write the following text in the Type box and Press OK.
So, we get all the data with cm as their suffixes.
1.3. Custom Format for Percentage
We have taken a data set consisting of numbers which we will convert to percentages using the % suffix.
➤ First, copy all the values of Column B in column C and select C5:C10.
➤ Then press CTRL+1 and the Format Cells window will open.
➤ Now, select the percentage option in the Type box and Press OK.
So, we get all the data with % as their suffixes.
Read More: How to Add Text Suffix with Custom Format in Excel (5 Examples)
2. Using Excel Flash Fill Feature to Add Suffix
We have a dataset of salaries. We will add a $ suffix using the Flash Fill feature.
➤ Fill the C5 manually with the proper suffix.
➤ And press CTRL+E.
Thus, we get salaries suffixed with $.
Common Excel Formulas to Add Suffix in Excel
1. Using CONCATENATE Function to Add Suffix
We have taken a dataset of names and email addresses. We will use the CONCATENATE function to add email addresses with the name
➤ Write the following formula in C5 and press ENTER.
=CONCATENATE(B5,C5)
Thereby, we have an email address suffixed to the name.
➤ Now, Hold and Drag the C5 cell downward.
Thus, we get email addresses suffixed to all the names.
Read More: How to Sort Numbers with Letter Suffix in Excel (4 Useful Methods)
2. Using & Operator to Add Suffix in Excel
We have a dataset for words and suffixes. We will use & operator and add suffixes to words.
➤ Write the following equation in C5 and press ENTER.
=B5&C5
So, we have a suffixed word in C5.
➤ Now Hold and Drag the C5 downward.
Thus, we have got all the words with suffixes.
Practice Section
You can download the workbook and practice the methods yourself.
Conclusion
Thank you for making it this far. We have tried to show you some ways to add suffix in Excel without formula with proper explanations using Examples. We hope you will find all these methods in this article helpful. In case you have any queries or suggestions about the methods, please leave a comment.
