G Guest Jun 19, 2007 #1 have a file full of lines like this Reg. Cab Long Bed 03-07 "Classic" is there a way to remove the 03-07 from the middle of a line?
have a file full of lines like this Reg. Cab Long Bed 03-07 "Classic" is there a way to remove the 03-07 from the middle of a line?
G Guest Jun 19, 2007 #2 If dates are all of the format of your example (yy-yy) then try: =LEFT(A1,FIND("-",A1)-3) & MID(A1,FIND("-",A1)+3,255) HTH
If dates are all of the format of your example (yy-yy) then try: =LEFT(A1,FIND("-",A1)-3) & MID(A1,FIND("-",A1)+3,255) HTH
