You're welcome.........yeah, I caught my mistake right after I pressed the
"send" button.....thanks for the feedback

Vaya con Dios,
Chuck, CABGx3



"Cheri" wrote:

Thank you - I had to adjust it to get the right numbers. It was a -5 at the
end.
But works great - thank you! Saves bunches of time.

"CLR" wrote:

=MID(A1,4,LEN(A1)-6)

Vaya con Dios,
Chuck, CABGx3



"Cheri" wrote:

I have a column with a string of 11 numbers. I want to drop off the first 3
and the last 2. What can make that happen.

Cheri