create a Formula Function that converts text to number and vice versa

[Jonathan.Trostad]

I would like a Function smilar to "atoi" and "itoa" in LISP. For whatever reason, some families have text parameters that are often populated with numbers. I would simply like a method to grab those numbers out of the text parameter, and use them in a formula, and then have the option of putting the changed item back into a text parameter if needed.

[dezindzer]

Sometimes you need to combine them, an example is:

if(and(Height=841, Width=1189), "A0",
if(and(Height=594, Width=841), "A1",
if(and(Height=420, Width=594), "A2",
if(and(Height=297, Width=420), "A3",
if(and(Height=297, Width=210), "A4",
"Custom &Height& x &Width& )))))

How I imagine this:

Height and Width would be Number Parameters, and with the help of & (or some other symbol) inside Quotation marks, it would be converted into text and displayed next to other text.

[Kevin.Bell]

Well I'm amazed this only has 16 votes...

This is a basic function that would be of real use when creating a schedule... 

If side screen width = 0 then "N/A"

[dezindzer]

Bump