Link specific cell within a line of text

[DebbyG]

Does anyone know how to put a formula/cell link within a line of text please?

such as, I would write within a cell: -

the current sales for this year is £**.**

£**.** would be the cell the amount would be linked to.

Many thanks


DebbyG

 

[fairwinds]

Hi,

Try:

="the current sales for this year is £ "&TEXT(A1,"0.00")

 

[DebbyG]

Thank you

that works prefectly.


DebbyG

 

[DebbyG]

Sorry... I only asked half a question.

What would I need to put if I wanted to add additional text after the formula link to the cell please?

Many thanks

 

[fairwinds]

="the current sales for this year is £ "&TEXT(A1,"0.00")&" some other text"

 

[DebbyG]

Thank you again...

Hopefully that is all I need on this particular issue.

Much appreciated