Formula to separate numbers from letters in string

[cmb80]

Hi all, I column A I have a mix of numeric alpha text. The number will always be first, but can range between 1 and 5 digits. The text can also range. In B I would like the number and in C the text.


Example being in A

10ORANGE
1473APPLE
2PEAR
672GRAPE
94PINEAPPLE

So in B I would have the number (10,1473,2,672,94) and in C the text (ORANGE, APPLE etc)

Thanks in advance

[zbor]

Here for number (B1):

Please Login or Register  to view this content.

Here for text (C1):

Please Login or Register  to view this content.

[cmb80]

Magic, thanks very much

[zbor]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.