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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, custom format 5
Formuala Question 7
Splitting Numbers into Columns. 3
COUNT DISTINCT problem 6
Automatically updating a workbook from a different workbook day by 4
mr t.valko ..help 8
SUMPRODUCT 3
Extracting data from two columns 4

Back
Top