Here is a video I made showing how to split apart cells into multiple cells in a spreadsheet for daily fantasy purposes. I use the Draftkings position as an example. When you download their salary export, you will get positions like PG/SG. That makes it tough for you to use in your research spreadsheet.
I show you how to automate this by using some functions and nesting them inside eachother. Mainly I use the LEFT, RIGHT, LEN and FIND functions and you can automate this process!
Watch the video to see how I do it.