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.


"domyrat" wrote:

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.