Hi guys
I need a formula
if Cell A contain TOUCHSCREEN return value "T" if its contain NO DISPLAY Return value "N" if its contain AUTO RESTART return value "A" if its contain LINES return value "L"
Call A1 Cell B1
TOUCHSCREEN T
NO DISPLAY N
AUTO RESTART A
LINES L
CRACK C
BSOD B
ODD O
I need a formula
if Cell A contain TOUCHSCREEN return value "T" if its contain NO DISPLAY Return value "N" if its contain AUTO RESTART return value "A" if its contain LINES return value "L"
Call A1 Cell B1
TOUCHSCREEN T
NO DISPLAY N
AUTO RESTART A
LINES L
CRACK C
BSOD B
ODD O