Hello,

I have some data that is saved in text and I want to be able to
manipulate it in Excel. The easiest way for me to explain it is to
provide an example. Some of my data is the following:


SERIAL NUM = 06Y911002651 APP CODE = TIM1 COMCODE = 201270600
ART MASTER = 2 SERIES = S3 VINTAGE =
SERIAL NUM = 06Y911000204 APP CODE = 44WW65B COMCODE = 109596015
ART MASTER = 1 SERIES = S5 VINTAGE =

Now what I would like to do is create 3 columns in Excel labeled

Serial Number APP CODE COMCODE
06Y911002651 TIM1-S3 201270600
06Y911000204 44WW65B-S5 109596015


Now I know I can get the Serial number and comcode easily but the APP
CODE is tricky.

I want to take the first part of the code and combine it with the
series and I know I can use

=CONCATENATE(,"-",) to do that

But I am having problems Extracting only the TIM1 and 44WW65B since
they are different lengths. And if I make the length to long using
MID() it will interfere with COMCODE.

So I am getting:

TIM1 COMC-S3
44WW65B-S5

(I am using trim to take out the extra spaces)

Any suggestions?