Combining Text and Formula Into Same Cell

Steveco

Hello all - I am trying to imbed a text string into a formula (using the NETDAYS() function).  The end result would be something similar to: "Number of days between Kick off Meeting and Final submittal is [RESULT]".  I am able to use the formula in a standalone cell with no text. In an adjacent cell, I am able to create a forumla with the text string, but not using the NETDAYS() function..  How do I combine the formulas in a single cell? Thank you for your help!

Joel Johnson

You should be able to do that...use a something like this....

 

="Number of days between Kick off Meeting and Final submittal is " + NETDAYS([FirstDate]1, [SecondDate]1)

 

Just use the plus sign as the conjunction between the text string and the formula.

 

Good Luck

Steveco

That worked. Thank you for the help!