convert formula to text

R

richard

I have created a formula using concatenate and I want it to be converted to
text.

How can I do this in Excel without using copy and paste special/values.

Seems strange that paste special is the only way to convert formulas into
values!!!
 
Top