=IF(LEFT(RC[2],1)=""0"",IF(mid(RC[2],10,2)=""-c"",LEFT(RC[2],11),LEFT(RC[2],9)),if(right(rc[2],2)=""-c"",RIGHT(RC[2],11),RIGHT(RC[2],9)))"

With the code above:
=IF(LEFT(RC[2],1)=""0"", - looks for zero(0) as the first character in the cell. I want to search for one(1) also.

If I change the "0" to "1" I get all that begin with 1. I need to find both "0" and "1"

Data I'm looking for:
09-B-6399
10-B-0568

Hopefully you can help, need this for work, creator has moved onto another company.

Dave