How can I get the first word from these examples?
<colgroup><col width="314" style="width: 313.33px;"> </colgroup><tbody>[TR]
[TD="width: 314, bgcolor: transparent, align: left"]Sprint MINI CATEGORIES[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Sprint_to_Fastest MINI CATEGORIES[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Sprint_to_Lowest MINI CATEGORIES[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Sprint_to_Day_Morning MINI CATEGORIES[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Sprint_to_Late_Night_Weekly MINI CATEGORIES[/TD]
[/TR]
</tbody>[/TABLE]
<strike style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; border-bottom-color: rgb(34, 34, 34); border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: rgb(34, 34, 34); border-left-style: none; border-left-width: 0px; border-right-color: rgb(34, 34, 34); border-right-style: none; border-right-width: 0px; border-top-color: rgb(34, 34, 34); border-top-style: none; border-top-width: 0px; font-family: sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: 100%; font-style: normal; font-variant: normal; font-weight: 400; line-height: 19.5px; outline-color: transparent; outline-style: none; outline-width: 0px; overflow: visible; width: auto;"></strike>
Assume this example is in cells A1 threw A5
I need to get results in cells B
1 threw B5 and I need them all to = Sprint
Any suggestions?
Thank you
MM