In my dim and distant memory I think I recall there is a way of nesting text (as memorandum only) in a cell formula, but it does not affect the formula calculation itself.
So e.g if I was to add two costs of £300 and £400 in a sum formula, it is simply =SUM(300,400) But if I want to add the detail in the formula that the costs were a taxi £300 and hotel £400 it was something along the lines of...
=SUM('taxi' 300, 'hotel' 400). The result of £700 would still appear as normal. Clearly this is not the correct syntax as it doesn't work but it was something similar to this.
If someone can please put me out of my misery I would be most grateful as I have been wrestling with this and cannot find solution on Excel help.