Thread: Extracting a word from a text string
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default Extracting a word from a text string
With your laptop description in cell A1, you can use this formula to
pull the screen size. This formula assumes the screen size will ALWAYS
include a double quote to indicate inches, and will ALWAYS be three
characters long.
=MID(A1,SEARCH(CHAR(34),A1,1)-2,3)

Reply With QuoteReply With Quote