Extracting Numbers and alphanumerics separatly from a cell

Hi,

I have a row of data in excel book. Each cell will have data like, Alphabets, Alphanumeric, Numerical. And space between each. Examples shown below.

I want to exact them as shown in eaxmples.

Eg:
CELL A1 CELL A2 CELL A3 CELL A4 CELL A5
ABCD EF12 3456 ABCD EF 12 3456

1. All the alphabets, moved to a cell
2. From Alphanumeric, Alphabets alone to the next available cell
3. From Alphanumeric, Numeric alone to the next available cell
4. All the balance numeric, need to be moved to the next available cell
5. And if we have multiples numeric series with space as break, then they should also need to be split to different cells.

Sample Excel sheet is also attached herewith.

Thanks
Balamurugan

Thank you so much... One more help would require in the same pattern

That is I want to extract only the set of numeric series from a cell. in that we should not consider the Alphabets & Alphanumeric both.

Originally Posted by BALA1983

I want to extract only the set of numeric series from a cell. in that we should not consider the Alphabets & Alphanumeric both.

Try

Please Login or Register  to view this content.

Originally Posted by BALA1983

I want to extract only the set of numeric series from a cell. in that we should not consider the Alphabets & Alphanumeric both.

Or perhaps

Please Login or Register  to view this content.

Thank you so much... But a small correction required.

in the above coding, numbers in alphanumeric is also considered. Whereas I want only the numeric series alone

Originally Posted by BALA1983

Thank you so much... But a small correction required.

in the above coding, numbers in alphanumeric is also considered. Whereas I want only the numeric series alone

See my last post.