Extracting Letters and Numbers in a random Alphanumeric String

Hi All,

I've got this problem: I need to separate around 40 alphanumerical entry in Column'A' to Columns'B','C','D','E'..

So, my Column'A' looks like,

A
1 5222208
2 T_5222213
3 522MN2207
4 TCM

And, I need the solution as, Column'A' -> Column'B' | Column'C' | Column'D' | Column'E'

i.e,

5222208 -> 5222208
T_5222213 -> T_ | 5222213
522MN2207 -> 522 | MN |2207
TCM -> TCM
A_522FOV1808 -> A_ | 522 | FOV | 1808
522DV2211 -> 522 | DV |2211

I read previous Threads and found no solution to this.

Please suggest.

Sanjay