I have a list of part numbers (some 5K) that I need to have broken out using
various criteria. The part numbers look like this:

C614C7010
CR3RHH7010
S418MCK7
N5432HX5P
C418MCX5

And they need to look like this:
A B C D E

C 614 C 7 010
C R3 RHH 7 010
S 418 MCK 7
N 5432 HX 5P
C 418 MCX 5

There is no specific trend to the data that I can use MID/Right/Left for.
Of note, I do have a separate sheet in my document that lists out all of the
combinations of Column B, C and E. Not sure if that is of any help here.

As an example, the Other Table contents look like the below as an example of
Column B

R3
418
614
5432

Any help is appreciated.