To add more text to a formula result in an Excel cell, put an ampersand (&) outside the end of the formula, then put a quotation mark ("). Type in your additional text, then close with another quotation mark ("). For example:
=text(now()-day(now()),"mmmm")&" paycheck"
This will returned the name of the month followed by the word paycheck. In December, it returned December paycheck. Note that there is a space after the first quotation mark. That is so there is a space between my result and my text. Without it, I would get Decemberpaycheck.
As always, I welcome your comments. Click on the Comment link below; it may say "No" or have a number in front of it.
=text(now()-day(now()),"mmmm")&" paycheck"
This will returned the name of the month followed by the word paycheck. In December, it returned December paycheck. Note that there is a space after the first quotation mark. That is so there is a space between my result and my text. Without it, I would get Decemberpaycheck.
As always, I welcome your comments. Click on the Comment link below; it may say "No" or have a number in front of it.
No comments:
Post a Comment
Put comments here.