=IF(D2="?0????",D2,LEFT(D2,3)) why dosen't it work

JQ · Oct 5, 2004

I am trying to find a string of charetors where the second cherecter is a
zerro and then either leve it or return three cherecters.

Frank Kabel · Oct 5, 2004

Hi
try
=IF(MID(D2,2,1)="0",D2,LEFT(D2,3))