There are many ways to add suffix in Excel. Out of those many ways, we will show you 2 easy ways to add suffixes in Excel without a 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.
How to add Suffix in Excel Without Formula: 2 Ways
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.
Read More: How to Add Text Suffix with Custom Format in Excel
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 Prefix with Custom Format in Excel
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
There are some common formulas using the CONCATENATE function and & operator 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.
2. Using & Operator to Add Suffix in Excel
We have a dataset for words and suffixes. We will use the & 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 all the words with suffixes.
Practice Section
You can download the workbook and practice the methods yourself.
Download Practice Workbook
You can download and practice from this workbook.
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.
