I'm working on a project for work where I need to turn SKU numbers (just a string of numbers and characters) into a regular word. For example, if the cell contains "sahara" (full cell is jmackey-sahara-XL), I want to have a corresponding adjacent column that says "Sahara." There isn't a consistent length to the beginning or ending of the SKU number, it varies for each product (upwards of 15 products). I have included an example list to show what I want to do. Is there any way to do this?
<tbody>
</tbody>
jmackey-sahara-L/XL | Sahara | L/XL |
jmackey-stealthy-S/M | Stealthy | S/M |
jmackey-recon-S/M | Recon | S/M |
<tbody>
</tbody>