Spreadsheet: 83517d1283472382-try-to-removing-characters-file1-2-1-
Sheet: Sheet1

R41462 |  | EC2AMB33962
R41823 |  | GBXBLV01902
B28435 |  | CB7BLV03929
[NAME] |  | CB1BLV02629 |  |  | In Column D, I have extracted the last 6 characters from Column C. using formula at D1 =RIGHT(C1,6)
B37659 |  | CB0BLV02931
B36123 |  | JCXBMR90222
B38777 |  | JC3BMR90420
R75288 |  | JC1BMR86396
R75294 |  | GB7BLR93938
R66974 |  | GB5BLR91900
R54857 |  | GB5ALR75288 |  |  | In Column B, at Cell B1, I use =COUNTIF(D:D,[NAME]). This looks at the adjacent cell in column A to see if it exists in Column D. A "1" means Yes and a"0" means No.
R67572 |  | GB4BLR89572
R63661 |  | GB4ALR65190
B37664 |  | GB0ALR75294
R65190 |  | GB7ALB36412
R60399 |  | GB6BLB40226
R75342 |  | GB6ALB37860
R73367 |  | GB4ALB35282 |  |  | My methods may not be overly complex but, I believe they may be easier to understand if you have limited experience.
B38734 |  | GB0ALB35053
R62668 |  | FC5BMB40416
B38850 |  | FBXALB37071
R67587 |  | FB2ALB38778
B35053 |  | FB2ALB35086
R77879 |  | FB1BLB40054
B34300 |  | EC9AMB37664
R73667 |  | [NAME]
R51294 |  | EC7BMB40399
R62305 |  | EC5AMB38777
[NAME] |  | EC0BMB40003
B32958 |  | DC9AMB38850
R57890 |  | DC3AMB34230
R78347 |  | JC2BMV07488
R70267 |  | GEXBMV08042
R51534 |  | GE9BMV03513
B38474 |  | GE5BMV02357
B36071 |  | GE5BMV00978
B34230 |  | GE4BMV08909
R56423 |  | GE4BMV08473
R65058 |  | GE4BMV08327
R67235 |  | GE4BMV04519
B37691 |  | GE4BMV01815
[NAME] |  | GE3BMV01496
B35086 |  | GE0BMV07689
R54871 |  | GBXBLV08022
R51320 |  | GBXBLV01667
B35539 |  | GB9BLV06553
[NAME] |  | GB9BLV03202
R58148 |  | GB9BLV01532
B36061 |  | GB8BLV08343
B38234 |  | GB7BLV09435
[NAME] |  | GB7BLV07894
B38255 |  | GB7BLV07586
R75303 |  | GB6BLV08888
B35282 |  | GB6BLV08860
B36412 |  | GB6BLV07000
B38778 |  | GB6BLV06994
[NAME] |  | GB6BLV05411
B37860 |  | GB5BLV07375
R56179 |  | GB5BLV07294
R70715 |  | GB5BLV07148
R69100 |  | GB5BLV06582
R74041 |  | GB5BLV06341
B37071 |  | GB4BLV08906
V05343 |  | GB4BLV02832
V08163 |  | GB3BLV07438
V08922 |  | GB3BLV07150
V01428 |  | [NAME]
V08311 |  | GB3BLV01428
V07122 |  | GB3BLV00957
V02704 |  | GB2BLV09004
V03473 |  | GB2BLV08998
R92338 |  | GB2BLV07298
R93708 |  | GB2BLV03395
R85137 |  | GB2BLV01792
R89442 |  | GB2BLV01744
B40225 |  | GB2BLV01551
R89495 |  | GB2BLV01257
R91900 |  | GB2BLV01159
[NAME] |  | GB1BLV09463
V01462 |  | GB1BLV06529
V01744 |  | GB1BLV04781
V02769 |  | GB1BLV01282
V06171 |  | GB0BLV06862
V03807 |  | GB0BLV05131
R81975 |  | GB0BLV01810
R83541 |  | GE9BMV03473
[NAME] |  | [NAME]
R90956 |  | CBXBLV09154
V09435 |  | CBXBLV05718
V06473 |  | CB9BLV07122
V01496 |  | CB9BLV06293
V07298 |  | CB7BLV07684
V01065 |  | CB7BLV06163
V08906 |  | CB7BLV05563
V08203 |  | CB7BLV04445
V07000 |  | CB6BLV07630
V06994 |  | CB6BLV06171
R89935 |  | CB5BLV08798
R93308 |  | CB4BLV08968
R93365 |  | CB4BLV07738
V08206 |  | CB4BLV06203
R94335 |  | CB3BLV08203
R85121 |  | CB3BLV03566
R88628 |  | CB2BLV08922
V06889 |  | CB2BLV08130
[NAME] |  | CB0BLV06473
R82634 |  | CB0BLV05551
R86331 |  | [NAME]
R87731 |  | [NAME]
R82161 |  | HEXBMR87324
R93850 |  | HE6AMR65058
[NAME] |  | HE5AMR70297
R81809 |  | HE4BMR86024
V07630 |  | HE1AMR74041
R82627 |  | GBXBLR89930
B40399 |  | GBXBLR89300
V06071 |  | GBXBLR81679
R84712 |  | GB9BLR84492
R87208 |  | GB9ALR58148
V08413 |  | GB8BLR81809
R87210 |  | GB8ALR73367
V08221 |  | [NAME]
V02467 |  | GB7BLR88041
R94311 |  | GB7BLR82627
V02832 |  | GB7ALR54857
V04781 |  | GB6BLR94610
V07684 |  | GB6BLR90332
R81653 |  | GB6BLR88628
R89450 |  | GB6BLR86331
R91151 |  | GB6BLR81789
V07375 |  | [NAME]
R91166 |  | GB5BLR87809
V01815 |  | GB5BLR85137
V06163 |  | GB4BLR88840
V01551 |  | GB4BLR88644
V08922 |  | GB4BLR85291
V05718 |  | GB4BLR82259
R88644 |  | GB4ALR51320
R89572 |  | GB3BLR88604
R87659 |  | GB2BLR88416
R86995 |  | GB2BLR82664
V02629 |  | GB2BLR81417
V09203 |  | GB1BLR88830
R81789 |  | GB1BLR84440
V09004 |  | GB1BLR81537
R91772 |  | [NAME]
V09531 |  | GB0BLR89807
V07033 |  | GB0BLR89287
V08163 |  | GB0BLR87250
R85111 |  | GB0BLR85787
B40003 |  | GB0ALR77879
V03929 |  | FBXBLR94823
R81537 |  | FBXBLR93056
R84476 |  | FBXBLR87208
V01902 |  | FBXBLR86687
V06792 |  | FB9BLR94568
V09154 |  | FB9BLR92741
V08851 |  | FB9BLR81965
V07036 |  | [NAME]
V02357 |  | FB8BLR93850
V04445 |  | FB8BLR87210
V06293 |  | FB7BLR94584
V08370 |  | FB7BLR91166
V08371 |  | FB7BLR89935
V06341 |  | FB6BLR94558
V04804 |  | FB6BLR87013
V00971 |  | FB5BLR94311
R87013 |  | FB5BLR93661
V05528 |  | FB5BLR91151
V08860 |  | FB4BLR94574
V05013 |  | FB4BLR92775
V06529 |  | FB4BLR92338
V09124 |  | FB3BLR94582
V06203 |  | FB3BLR93268
R90352 |  | FB3BLR87731
V07389 |  | FB3BLR82237
R94586 |  | FB2BLR93892
R93661 |  | FB0BLR88397
R94558 |  | FB0BLR83541
R94823 |  | [NAME]
R94582 |  | FA8AHR63661
R94584 |  | FA6AHR62668
R94574 |  | [NAME]
R93552
R94542
V06553
[NAME]
V07738
[NAME]
V00911
V08130
V06096
B41060
R94568
V08381
V01810
R87250
V08397
V01792
V04924
R93938
R93892
V01745
V08411
V07689
B40775
V05563
V07062
V08226
V08798
V01838
V07407
V02703
V06990
R89645
R87689
V06868
[NAME]
V05131
V08473
R90472
[NAME]
R86082
R93056
R90420
R89287
B40418
R91154
R89295
R87749
B40352
R84492
[NAME]
[NAME]
V03513
V07360
V08888
V01864
V07165
V08968
V07015
V08071
R86024
V02089
[NAME]
R81965
B40054
V07438
V02256
[NAME]
V02931
R91535
V05593
V04996
V07294
B40416
R88397
R92295
R88748
R81417
V01667
V08941
R88960
V03395
[NAME]
R85893
V08305
V01257
R88416
B39401
V07693
V02251
V07853
V01096
R82874
V07512
V06960
V08374
R85059
V03202
R87324
V07586
V08022
R85291
R85787
R87809
R88830
R94432
R84434
[NAME]
R93665
V03206
V02446
V05343
R84430
R94610
R89965
V07148
[NAME]
R84440
R82259
R89012
R87817
V07894
B40226
B39979
V07810
R81679
V01837
V02793
R92775
V06285
V06201
V06862
R92741
V08327
V07345
V08909
B39617
V06582
V08343
R93268
R89807
R91722
V00957
V01532
V07150
V08998
R86687
V05551
V00978
R90222
V05488
R89300
V07488
V09110
V08245
V05661
R87717
B40337
V07651
V01282
V05411
V09199
V06748
B40635
V01159
V03566
V06309
V05526
R88041
R88604
V09463
R83393
V08042