Bad result
What's in I63 and what's in A63, your example looks strange since it looks
like A63 is to the right of I63?
What does =LEFT(I63,2) return?
also you can try to see if it makes any difference if you use
=IF(LEFT(TRIM(I63),2)="41","TGH"&MID(TRIM(A63),3,5 ),I63)
--
Regards,
Peo Sjoblom
"Arlene" wrote in message
...
176.51 H083 02/01/2007 0:00 HAUL 1081 6.5 P 601 41805 H TGH6.51
=IF(LEFT(I63,2)="41","TGH"&MID(A63,3,5),I63)
I have this formula attached to this line and the result should be TGH805
instead it comes out TGH6.51 can anyone please explain. Thanks
|