Hi,

I have a problem in separating the numeric data.For example

Row Column A
1 Manakamana Flour Mills Pvt.Ltd.Siliguri
2 Kelimo Pvt.Ltd.ltm(300064698)

There has been a lot of data like this but of varying length.Hence I want a formula that separates numeric data from both cases just as mentioned in row 1 where there is no numeric data and in row 2 where there is numeric as well as non numeric.

Secondly,I want to separate further list of names (Non numeric Data) from above row 1 and row 2.

Can anyone suggest me the right formula for this.

With Best Rgds,
Suresh