Try this:

="Interest Rate "&A1&" %"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Dave" wrote in message
...
I have a cell at the top of a column with Text identifying the column below.

I want to use the value in another cell in this text field.

Example Cell A1 = 5 Text Cell B1 = Interest Rate "A1" %

So the end result would be Interest Rate 5 %

Example Cell A1 = 8 Text Cell B1 = Interest Rate "A1" %

So the end result would be Interest Rate 8 %

How do I do this?

Thanks