Parsing Serial Numbers?

  • Thread starter Thread starter davegb
  • Start date Start date
D

davegb

I inherited a spreadsheet 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.
 
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
 
Back
Top