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