Title: How To Make a Fantasy Football Cheat Sheet in Excel
Headings: How To Make a Fantasy Football Cheat Sheet in Excel
How To Make a Fantasy Football Cheat Sheet in Excel
Tab 2 through 5
Key Points
Attribution
About Kurt Turner

Content: 2. All player names and team names will need to be sanitized because some of them will have a leading or trailing blank space, which will need to be remove for the formulas to work. This is done using the =trim function in excel. Watch this youtube video if you don’t know how to do this. YouTube
Basically, after you import the data you’ll insert a temporary column next to the column you want to sanitize. Let’s say you’re removing blank spaces (sanitizing) from the players name in column b2. In A2 you’ll type =trim (b2). This will remove the blank spaces in B2 and place the sanitized version in A2. Now simply drag A2 down and it will sanitize the rest of the player names. You’ll have to copy the sanitized names and paste them over the original names.