Excel custom format q

[domyrat]

There is one problem that needs help from experts.

I got data:

Cell A1: AA-BB-999-xxxxx-zz-Abcdefghij Klmno 9, PRSTUVW
Cell A2: AA-BB-888-zzzzz-zz-Abcdef Ghijk 8, LMNOPRSTUV
....
....
....

In B1 and C1, B2 and C2 i need this:

B1: Abcdefghij Klmno 9
C2: PRSTUVW

B2: Abcdef Ghijk 8
C2: LMNOPRSTUV

....
....
....

Data entries are not the same length.

 

[Mike H]

No need to start another thread, the answer Jacob gave you in your previous
post does what you are asking unless of course you not explaining the problem
correctly.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Jacob Skaria]

Please refer your other post

 

[domyrat]

Sorry for reposting, something was wrong with my internet connection, so i
didnt see the post.

Thank you Jacob