View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SS[_2_] SS[_2_] is offline
external usenet poster
 
Posts: 12
Default select only certain characters from a cell.

I have a cell with something like

NT7230UNAGGLOPUMP

I want another cell to read this one but only take out the UNAGGLO bit of
it.

IE only characters 7 through 11.

I want another cell to take only the last 4 characters and thus display
PUMP.

how can I do this??

SS