Text and Formula in same Cell

[AllenMead]

I need to have a cell that contains text and the results of another cell which should for example read as follows;

Total Cost of Orders Issued (233)

the number 233, is the result of a forumula in another cell.

I can do it for a date as follows but not sure on how to reference another cell

Please Login or Register  to view this content.

Any Help would be much appreciated!

[romperstomper]

For example:
="Total Cost of Orders Issued (" & B1 & ")"

[edvwvw]

Try this

="PROPERTIES ON SITE AS OF "&TEXT(TODAY(),"dd/mm/yyyy")&" "&D4

where the formula is in D4

edvwvw

[AllenMead]

@romperstomper - spot on exactly what I need!!

Another scenario I have is where I also need to include text inside the brackets after the cell reference had a 'fiddle' but couldn't get it to work.

@edvwvw again, spot on, thank you.

[romperstomper]

Do you mean:
="Total Cost of Orders Issued (" & B1 & " some more text here)"

[AllenMead]

Spot on chap! Much appreciated!