Excel custom format q

  • Thread starter Thread starter domyrat
  • Start date Start date
D

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.
 
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.
 
Sorry for reposting, something was wrong with my internet connection, so i
didnt see the post.

Thank you Jacob
 
Back
Top