Here's one way:

A1 = 25% (formatted as %)

=A1*100&"% of Total"

--
Biff
Microsoft Excel MVP


"FHM12" wrote in message
...
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.