Insert a "VALUE" in a paragraph

[Steve66]

A few years ago, I wrote a spreadsheet where within a paragraph, I inserted "VALUES" from various places throughout the spreadsheet. Now I can't figure out how I did it. I need it set up so if I change the "VALUES," it changes the "VALUE" in the paragraph.

In the attached sample, I have used the cell names where I want to insert the corresponding values and formulas using cell names, where I will be doing calculations using those same values. I've also added a section where certain calculations are done to give my NINJA a better idea of what I am trying to do.

Thank you in advance for your assistance.
Steve

 

[Awesome Wally]

Steve, You just need to write the Paragraph like one big concatenated formula with " " and & signs between the string text and named range values. See if the attached is what you had in mind.

P.S. you didn't have a Named Range Value for TERM.

 

[Steve66]

Thank you Awesome Wally!! As soon as I saw what you wrote in the formula, it dawned on me that I was putting the quotations around the formula, instead of around the text.