Hello Team ,

I need to split data in
cell A1 "1Apples Red 2Oranges Citrus 4Plums 167Rose Yellow" into column data with numbers as delimiters :

A B C
1 Apples Red
2 Oranges Citrus
4 Plums
167 Rose Yellow

Thanks in Advance.
Mani