Thread: extracting information from a certain place in one cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default extracting information from a certain place in one cell
Will the extracted phrase always be 5 characters in length? If so:

=MID(A1,35,5)

HTH,
Elkar


"Wooddy" wrote:

I want to extract a certain alpha numberic phrase within a cell which is
always in the 35th place. I want to extract the N21S8 for all rows in my
spreadsheet.

ie: E300 CB 210X425 STD CEUT E N21S8

Reply With QuoteReply With Quote