=concatenate("1 in ",[your formula]).

The concatenate function joins two strings together, in this case, a text
string and a claculation.

Example: =CONCATENATE("1 in ",(A1/B1)) would return [1 in (A1/B1)] where
A1/B1 is your calculation.

Make sure that the "1 in ", part of your function is exactly as I put it
above, otherwise you'll either get an error, or else, will have spacing
issues between the "1 in" part and the calculation.

Dave
--
Brevity is the soul of wit.


"CD13" wrote:

Hi, first post here...looking to show a conversion ratio in my formula
results ona spreadsheet. I want the results formatted to show Ex: 1 in 90,
where the 90 is calculated by a formula and "1 in" is text. Please assist :)
Thanks!