Try: =IFERROR(MID(E3,2,10)+0,""), this will return a blank cell, without the IFERROR function you will receive an error message. May I know the string in E3 from which you are trying to extract 10 characters?