View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Cheri Cheri is offline
external usenet poster
 
Posts: 53
Default 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