Hello,

I have a cell with 7 digits, but it may go up to 8 digits at anytime. I need to automatically either extract the 6 digits on the left of the 7 digits or the 7 digits from the left of the 8 digits.

example:

B1. 7634471 (I need just the 763447) =left(B1,6) works alone fine for 6, but what if it reads 76344719? I now need the 7634471. I tried the If and Len statement but it always only grabs the left 6 digits.

Thanks for your help.