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