Rose
Send me your file along with that "separate sheet in my document that
lists out all of the combinations of Column B, C and E." That list is the
key to doing this. My email is . Remove the
"extra" from this address. HTH Otto
"rosefest" wrote in message
...
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.