Re: Parsing Serial Numbers?

Hi

As I uderstood, there is 2 formats, both of fixed length. Then maybe
positions for groups are fixed for group - when yes, then something like:
B1=IF(LEN(A1)=10,LEFT(A1,3),LEFT(A1,4))
C1=IF(LEN(A1)=10,MID(A1,4,4),LEFT(A1,5))
D1=RIGHT(A1,3)


Arvi Laanemets


"davegb" <davegb@xxxxxxxxxxxxxx> wrote in message
news:1114536545.897777.131480@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I inherited a spread*** with computer serial numbers in it. For
> various purposes, I'd like to be able to parse these into 3 groups. The
> problem is that there are 2 formats, a 10 character format and a 12
> character format. Each would be parsed differently. I looked for a
> parse function in XL and was very surprised that there isn't one. I
> thought I could to a test for the number of characters (Len function),
> and with an If statement, do 2 different parses based on the outcome.
> Is there no way to do this with a formula? Do I have to write a macro?
> I did look at Data, Text to columns, but it doesn't appear to
> accomodate this situation. Any ideas?
> Thanks in advance.
>


.