Separate text numbers and characters into coulmns

[Tellm]

I have the following type data given below and I need to separate each of the groups whether it be text, numeric or character into individual columns .

The data is:
ACC30X30X6
30X30X6ACS
ACS30X6
BSC25*25*8
25*40*8DDF

and as an example I would like it to be: acc | 30 | x | 30 | x | 6

Does anyone have an idea as to how this could be achieved whether by formula or coding?

Thanks

[Special-K]

What about the other lines as some of them don't conform to the same format, e.g. line 3 ACS30X6, how should that be split?

[Tellm]

Special-K - just the same: ACS | 30 | X | 6

Thanks

[lecxe]

Hi Tellm

With the strings in A1, down, try:

Please Login or Register  to view this content.

The code splits the text displayed in the cells and writes the result in the cells to the right.

[Tellm]

Lecxe - this is perfect, many many thanks.

[lecxe]

You're welcome. Thanks for the feedback.