Split Text

[nuwara1973]

hi,
i have a text string in a in one cell (say A1) as 123start392 (with out space)
I need a formula to spit this string into "123" into one cell and "start" into another cell and "392" in to another cell using a formula.

thanks

 

[AliGW]

Please give a longer representative set of data: are all text strings the same pattern?

 

[nuwara1973]

Please give a longer representative set of data: are all text strings the same pattern?

no there are no identifiable patterns.

example

12apple300
23graps black500
100strawberry12300

there can be multiple numbers in the start. and in between there are some words followed by some figures.
i need to separate them into different cells. the words (text) in between some times have a space. but the maximum characters in a cell will not exceed 50.