="this quote..." & text(a1,"$#,##0.00") & " and is due " & text(b1,"mm/dd/yyyy")

Joe Reyes wrote:

Is there a way to enter a function into a sentence in Excel? As in the
following example, I am trying to type a sentence with a function to
automatically display the results of a cell in the same sentence:

This quote is based on an total lump sum estimate not to exceed "$10,000"

--

Dave Peterson