Try this in a cell:-

="First bit of my sentence " & A1 & " another bit of writing "

Purs whatever is in A1 in the midle.

Mike

"FHM12" wrote:

I want to link a specifc number into the middle of a sentence in a different
cell.

Example: "x% of Total" where I'm pulling x from another cell.