Lesson#47: Three ways to add a default word to any formula result in Excel

Puspendu Roy Karmakar Posted on February 13, 2018 Posted in Excel Features No Comments

This post shows three ways to add any default word to the formula result.

Here I have to calculate the difference between two dates and need to show the word “Days” with the result.

1. By using “&”
I have used the formula =B2-A2 &” Days”

2. By using the function CONCATENATE

I have used the formula =CONCATENATE(B2-A2,” Days”)

3. Format Cellsa. Right-click on the cells and click on Format Cells.

b. Go to Custom in Number tab and select the 0 below General.

c. Write “Days” after 0 below Type:
d. Click OK.

e. Put just =B2-A2 to calculate the difference and it will show “Days” after the formula result automatically.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.