Extracting a word from a text string
 

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?

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)

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)

Extracting a word from a text string
 

Thanks a ton Dave. It helped.

"Dave O" wrote:

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)