="We may charge you $" & format(A1,"#,##0.00") & " fee if item is not
returned in good condition."

HTH,
Gary Brown

"Abi" wrote:

Let's say I have a string of text in a cell, something like:

"We may charge you $XXX fee if item is not returned in good condition."

Is it possible to make that XXX a formula/calculation (based upon
information entered in another cell)?