Text formula

[shuklaankur281190]

Hi,
Thanks for your videos. I have a question as below.

I have a table containing some products.
RCCO NK-3325 TRD 633 PL 1 KG NK IN
RCCO NK-3325 TRD 633 PL 2 KG NK IN
RCCO NK-5251 TRD 633 PL 1 KG NK IN
RCCO NK-5251 TRD 633 PL 2 KG NK IN
RCCO NK-6302 TRD 633 PL 1 KG NK IN

Brand is
NK-3325
NK-5251
NK-6302

NK is a brand and after NK digits are verity. Almost 20000 rows are filled with the same as above. Now i want to put a formula for getting Brand and verity only. Some times Brand and verity somewhere in middle.

Please help me.

 

[shuklaankur281190]

Yes Mr.Rick you are right, I founded my answer but if you can also solve above said problem. It will be grateful act for me.

If there is a brand list in D column and product description in A column , how to find brand list, containing with product description cell and if contain brand name then answer should be Same brand name.

Thanks for you marvelous supports.