Turn numbers into "predefined" text

[intelligent_time_151]

How do you – if possible – automate excel, in the sense of having a "predefined text template" and then filling a number from another cell in?

Specifically, I have calculated the percentage revenue increase for a company from one year to the next, and I have another cell that says "Revenue this year was X% higher than last year". How do you substitute the "X" for the actual number?

Thanks in advance.

 

[Fluff]

Hi & welcome to MrExcel.
How about

="Revenue this year was " & TEXT(C2,"0%") & " higher than last year"

Change the C2 to the cell with your percentage.