Deleting numbers in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Sorry, mis-read the post........

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

Vaya con Dios,
Chuck, CABGx3
 
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.
 
You're welcome.........yeah, I caught my mistake right after I pressed the
"send" button.....thanks for the feedback

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate data into two columns 5
Macro to add numbers in a text string 5
Formatting SSNs 7
Formatting names in a list 5
Counting strings of consecutive numbers in a column 1
Code for counting number of word strings? 1
Formula to return a value for a portion of a text string in a cell 2
Filters 3

Back
Top