C
Cheri
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
and the last 2. What can make that happen.
Cheri
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
=MID(A1,4,LEN(A1)-6)
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3
R
rpalarea
According to Excel help file, you might try to use the functions LEN, LEFT,
RIGHT. I found the answer by going to help and searching remove characters. I
have not used the functions, so I have not offered the actual syntax, but
this looks to be correct.
Rich
RIGHT. I found the answer by going to help and searching remove characters. I
have not used the functions, so I have not offered the actual syntax, but
this looks to be correct.
Rich
C
CLR
Sorry, mis-read the post........
=MID(A1,4,LEN(A1)-5)
Vaya con Dios,
Chuck, CABGx3
=MID(A1,4,LEN(A1)-5)
Vaya con Dios,
Chuck, CABGx3
C
Cheri
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.
end.
But works great - thank you! Saves bunches of time.
C
CLR
You're welcome.........yeah, I caught my mistake right after I pressed the
"send" button.....thanks for the feedback
Vaya con Dios,
Chuck, CABGx3
"send" button.....thanks for the feedback
Vaya con Dios,
Chuck, CABGx3