Sorting column with numbers and letters Excel 2007

**dark91zc** · 09-04-2013, 06:00 PM

Hello All,

What i am trying to do is apply sorting to column C. the basic data looks something like this OL0001A01 or OL0012D05, From another sorting macro I have I believe that it might look something like this

"=(Left(C2,6) &Mid(C2,5,1) &Right(C2,2)) *1"

It will need to be sorted in to column I then go back to C.

I think it is Range and Sort.

Thanks

**dark91zc** · 09-06-2013, 01:59 PM

To the top.

**dark91zc** · 09-06-2013, 02:31 PM

Ok this is a very small table of what I am working with.

395659 395659 OL0002D01 2002 02-2693 / 02-2841
394588 394588 OL0001A05 2001 01-3780 / 01-3949
394591 394591 OL0003A03 2001 01-3950 / 01-4140
394465 394465 OL0012C04 2001 01-4141 / 01-4319
394499 394499 OL0012D04 2001 01-4321 / 01-4510
394546 394546 OL0006C01 2001 01-4511 / 01-4683
394556 394556 OL0006C04 2001 01-4684 / 01-4865
394555 394555 OL0006C01 2001 01-4866 / 01-5019
394451 394451 OL0009C01 2001 01-5020 / 01-5219
394433 394433 OL0009C02 2001 01-5220 / 01-5382
394422 394422 OL0010C01 2001 01-5383 / 01-5558
394448 394448 OL0010C05 2001 01-5559 / 01-5732
394458 394458 OL0009C05 2001 01-5733 / 01-5887
394462 394462 OL0011C01 2001 01-5888 / 01-6059
394423 394423 OL0011C03 2001 01-6060 / 01-6245
394440 394440 OL0011C01 2001 01-6247 / 01-6416
394625 394625 OL0004A02 2001 01-6417 / 01-6575
394439 394439 OL0011C02 2001 01-6576 / 01-6743
394437 394437 OL0010C02 2001 01-6744 / 01-6904

The column with OL0002D01 is what i am try to sort and arrange.