How to separate numerics from names to create a new column

Hi, I need to separate the numerics from the names. The numerical value has to be arrived in a new cell.

Example:

Column A contains the details like-"Samson45"

Need to separate the numerical from the name.

Pls help me with the excel function.

Thanks!

If your name is in A1, then in B1 enter:

=TRIM(LEFT(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1& "1,2,3,4,5,6,7,8,9,0"))-1))

In C1 enter:

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),LEN(A1))

Thanks!! Tried this and it's working. the name is "Deepak Balakrishnan [5]"

When i entered the above formula, i get one "Deepak" and 5]

I need "Deepak Balakrishnan" and [5] to be in seperate cells.

Should the brackets be included, or can it be just the #?

The brackets to be included..