Excel custom format q
 

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.

Excel custom format q
 

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.

Excel custom format q
 

Please refer your other post


"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.

Excel custom format q
 

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

Thank you Jacob

"Mike H" wrote:

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.