Parsing Text

[DataBlake]

So i have a unique issue that i don't have the slightest clue how to solve. So in column C i need to seperate "Pirelli Scorpion A/S" , "Pirelli PZero Nero GT", "Lexani LXHT-106". Basically the first item is a size which we need to exclude xxx/xxRxx or xxx xxRxx and then followed by what i need: the description. followed by a load, speed, and style which need to be exluded. Unfortunately some of the things are irregular like line 30. what i need is "Azenis FK510"

i know this looks all over the place but here are some helpful notes:

1. A/T, H/T, M/T, A/S are included in the descriptions i need
2. The load/speed to exclude are located in rows E and F
3. XL, BLK, SL, MO, NO, N0, MO on the ends or immediately after the size should be excluded.

I will link the excel sheet in case there is anything i missed that you can spot. Any help would be GREATLY appreciated.

https://docs.google.com/spreadsheet...vBpAluy_U6PuazAW8gx5zMUKa-bZr/pub?output=xlsx

 

[KUYJS]

Try
=Left(Trim(Right(C2,Len(C2)-Len(D2))),Search(E2,Trim(Right(C2,Len(C2)-Len(D2))))

 

[DataBlake]

Try
=Left(Trim(Right(C2,Len(C2)-Len(D2))),Search(E2,Trim(Right(C2,Len(C2)-Len(D2))))

Your solution (column J) works for some of them, but i'm thinking this may be a VBA solution. example: on line 1 there is a +!, #Value is returned on ones where XL is in the front, etc. It does help clean up and make my job easier though <3 appreciated.