change numbers to words

[aranechan]

hi there, i'm newbie in this forum.
hopes i'm posting in the right forum....

here is what i'm trying to make...

when i enter any number (up to 10 digits) in cell A1, cell B1 will change this way....

if the number is 982497 then in B1 will say "nine mouse eight worm two owl four snake nine cat seven dog"

mouse, worm, is the words i define from the number's order (right to left) (see my attachments)
I NEED FORMULA THAT NOT JUST DEFINE THIS CONDITION, THAT I CAN CHANGE IT TO ANYTHING.

the number is any numbers between 1-1,000,000,000.

thanks.

PLEASE CHECK THE ATTACHMENT TO UNDERSTAND WHAT I WANT.

[MarvinP]

Hi,
In your first example on the attached:

985236578 = nine eagle eight fish five monkey two mouse three worm six owl five snake seven cat eight dog

You have 8 Fish on the first 8 and 8 Dog on the second. How do we know "what you want" for each 8?

[StephenR]

I've actually posted a formula solution in your other thread. Others could probably do it better.