hello
I would delete theses from sheet1,sheet2(TT,13TM,12TA,TN,TD,-) . the sheet1 should delete from column B , but the sheet2 should delete from columns B,C .about the hyphen should just delete before 12MR ,22TM.
sheet2
note: my data are about 500 rows into two sheets
I would delete theses from sheet1,sheet2(TT,13TM,12TA,TN,TD,-) . the sheet1 should delete from column B , but the sheet2 should delete from columns B,C .about the hyphen should just delete before 12MR ,22TM.
zz.xlsx | |||
---|---|---|---|
B | |||
1 | brand | ||
2 | CC 2500M14 TT 11TM NN1 GER | ||
3 | CC 2500M14 13TM TN T123 GER | ||
4 | CC 2500M14 11TM T123 TN GER | ||
5 | CC 2500M14 11TM NN1 TT GER | ||
6 | BBW 1248-23 TL-ML 13TR NN IT | ||
7 | FG 12456TR40***** 22TM TT 1445V IT | ||
8 | DF 125/22MT23.5-22TM SL200 GER | ||
9 | MLC 111MR12L 12TM TD SV123 IT | ||
10 | NN 123/34T22.5-12MR SS1/1 NN GR | ||
SHEET1 |
sheet2
zz.xlsx | |||||
---|---|---|---|---|---|
B | C | D | |||
1 | BRAND | TY | OR | ||
2 | CC 2500M14 TT 11TM | NN1 | GER | ||
3 | CC 2500M14 12TA | T123 TN | GER | ||
4 | CC 2500M14 11TM TN | T123 | GER | ||
5 | CC 2500M14 11TM | NN1 TT | GER | ||
6 | BBW 1248-23 TL-ML 13TR | NN | IT | ||
7 | FG 12456TR40***** 1445V | 22TM TT | IT | ||
8 | DF 125/22MT23.5-22TM ML-120 | SL200 | GER | ||
9 | MLC 111MR12L 12TM | TD SV123 | IT | ||
10 | NN 123/34T22.5-12MR | SS1/1 NN | GER | ||
SHEET2 |
note: my data are about 500 rows into two sheets