Formula to pull values in a specific position WITHIN a cell?

[ncjefffl]

I need a formula that will look in a cell and give me a certain substring of whatever data is in there. I'd like to write, =Substring(Left(A1,8,2)), meaning start at the far left of cell A1, move over 8 "spaces", and give me whatever is in the 8th and 9th space. Of course, I can't write it that way. Is there ANY way to phrase it so Excel would understand?

 

[pgc01]

Hi

Check the help on the function MID()

 

[ncjefffl]

Thanks SO much!!!