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

could use someting like

Please Login or Register  to view this content.

to delimite the text then split it up

or all togeather

Please Login or Register  to view this content.

Hey rajbhar_s can you please mark the post solved?

This is better using the match collection

Please Login or Register  to view this content.