Deleting numbers in a string
 

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

Deleting numbers in a string
 

=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

Deleting numbers in a string
 

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

"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

Deleting numbers in a string
 

Sorry, mis-read the post........

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

Vaya con Dios,
Chuck, CABGx3



"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

Deleting numbers in a string
 

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

Deleting numbers in a string
 

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