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

Lesson#47: Three ways to add a default word to any formula result in Excel
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.

See also  Lesson#113: How to highlight cells with errors in it

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*