Applications text string in excel.

[thanhvanchi]

Hello all member!

VENDOR NAMES ARE MICROMAX, INTEX AND SPICE.
Variations of the strings include (from my observations)

Intext variations

SM DUAL SIM MOBILE PHONE BRAND INTEX WITH TOUCH SCREEN 4"" W/O TV MODEL AQUA 3G PRO (WITH VALID IMEI NOS.)"
"INTEX AQUA ACE GSM MOBILE PHONE DUAL SIM ,WITH CAPACITIVE TOUCH 5"",(BIS NO.R-41021288 DT. 14.09.2015) (WITH VALID IMEI N"

Micromax Variations
MOBILE PHONE - MICROMAX Q392 3G GSM MOBILE PHONE (BIS R-41012319) DUAL SIM, WITH TOUCH SCREEN SIZE 5 INCH, WITH ASSY'S,
GSM MOBILE PHONE X601 DUAL SIM [W/O MICRO SD CARD] WITHOUT TOUCH SCREEN, (BRAND: MICROMAX)

Spice Variations
"SPICE FLO-6111 STAR GSM MOBILE PHONE DUAL SIM CAP TOUCH 4"" W/O TV FAC.W/O SD (W/VALID IMEI NO.NOT FAKE/DUPLICATE IMEI NO"
BRAND:SPICE POWER-5511 GSM MOBILE PHONE DUAL SIM W/O TOUCH W/O TV FAC.W/O SD CARD (W/VALID IMEI NO.NOT FAKE/DUPLICATE IMEI NO

Things Ive tried include

1) vlookup, mid, trm, len, find, search , replace symbol then text to column.
2)Any other solutions for this ? Apprecaite the response.
3) Ideally the output shoudl be done accurately without any mistakes under 20 minutes.

Have a nice day.
QC: công ty chuyên về dịch vụ internet fpt nam định và internet fpt lào cai và internet fpt lạng sơn cho khách hàng có nhu cầu.

[AliGW]

What is the output you require?