or

=text(a1,"0.00%") & " of total"

(or use the percent format of your choice)

"T. Valko" wrote:

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.

--

Dave Peterson