| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Duplicate Numbers In A Column: How ? | New Users to Excel | |||
| deleting numbers in a column | New Users to Excel | |||
| Column of Numbers in xls to String of Numbers in txt | Excel Discussion (Misc queries) | |||
| Deleting characters that are not numbers | Excel Discussion (Misc queries) | |||
| how do I delete numbers without deleting formulas | Excel Discussion (Misc queries) | |||
Linear Mode
