I need to produce a spreadsheet that rights the example: 1,245.89 as one two
four five 89. I've tried the left and right formulaes and the len one but the
numbers will change in length and may have zero decimals at the end too. Not
sure how to set this up now. Need the numbers in seperate cells, currently
have the following formula for the second number and so forth:
RIGHT(LEFT(B3,2),1)

Any help would be much appreciated.

Many thanks.