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

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


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

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

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.

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.

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 got all the words with suffixes.

add suffix in excel


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.


Related Articles

Sourav Kundu

Sourav Kundu

Bio: Hi, I am Sourav Kundu. I live in Adabor, Dhaka. I graduated in Naval Architecture and Marine Engineering from BUET. I am really excited to be a part of SOFTEKO family. I want to develop my research skill and find innovative solutions for the given problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo