How to Add Suffix Without Formula in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

Add Suffix in Excel Without Formula

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

0.0 “Kg”

add suffix in excel

Thus, we get all the weight values suffixed with Kg.

Add Suffix in Excel Without Formula

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.

add suffix without formula

First, copy all the values of Column B in column C and select C5:C10.

Add Suffix in Excel Without Formula

Then press CTRL+1 and the Format Cells window will open.

Now, write the following text in the Type box and Press OK.

0.0 “cm”

So, we get all the data with cm as their suffixes.

add suffix in excel


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.

Add Suffix in Excel Without Formula

Then press CTRL+1 and the Format Cells window will open.

Now, select the percentage option in the Type box and Press OK.

add suffix in Excel

So, we get all the data with % as their suffixes.

Add Suffix in Excel Without Formula

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.

add suffix in excel

Fill the C5 manually with the proper suffix.

And press CTRL+E.

Thus, we get salaries suffixed with $.

add suffix in excel

 


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

add suffix in excel with formula

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.

add suffix in excel using formula

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.

add suffix in excel using formula

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.

add suffix in excel with formula

Thus, we have all the words with suffixes.

add suffix in excel


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sourav Kundu
Sourav Kundu

Sourav Kundu, BSc, Naval Architecture and Marine Engineering, BUET, Bangladesh, has been a part of the ExcelDemy project for 1 year. He has written more than 70 articles and 12 comments for ExcelDemy. Currently, he is working as a Exceldemy team member writing contentful articles. His work and learning interest revolves around data analysis. He has been working Microsoft Office Suites, and MS Excel for Data Analysis, and developing Excel Applications. Besides he has been working on Excel VBA and Excel Dashboard to learn more about data analysis.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo