Sorting column with numbers and letters Excel 2007

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