Hello,

How can I trim the result of my Vlookup?

=SUBSTITUTE(VLOOKUP($B13,'ESR - Dowload'!$A:$W,20,FALSE),"828"," ")

I have this formula, to change 8281B7005 into 1B7005. That works fine.

How can I trim the "1B" and "005" off the result? I need to set the formula so that it removed the first s characters and the last 3 characters so I'm left with 7.

I've looked at TRIM and Upper/Lower but I cant make it work.

Thanks