I need a formula

[Ima_learnin']

A1 contains oxfordCT06478 I need a formula in cell B1 that will return everything left of the C and a formula in cell B3 that will return everything right of the T.

Thanks

 

[Aladin Akyurek]

=LEFT(A1,FIND("CT",A1)-1)

=REPLACE(A1,1,FIND("CT",A1)+1,"")

 

[NBVC]

Try these.

=Left(A1,Find("C",A1)-1)

=Mid(A1,Find("T",A1)+1,Len(A1))

 

[Ima_learnin']

you're brilliant!