Extracting a word from a text string

N

Nadeem

I have a text string describing a laptop "Toshiba 17" LCD black". There are
hundreds of tme with different sizes of the screen. I want to be able to
extract the screen size 17", 14" etc and put them in a new cell for further
analysis. Can anyone help?
 
D

Dave O

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)
 
D

Dave O

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)
 
Top