- Posts: 6
- Joined: Tue Aug 28, 2012 3:34 am
Fixing this in Excel is pretty easy.
1. Insert a column to the right of the player names column
2. Use the RIGHT$ [that's a dollar sign, not an S] function in the new column <=RIGHT$(cell number from name column)> and copy it downward through the set
3. Sort on this new column [Data sort]
4. Replace all (*) with L, all # with (S) and all other last characters with (R).
You're done with that. You should be able to handle the rest with alpha sorts and a little manual editing.
(That doesn't mean Strat shouldn't start trying to be a little more customer-friendly. It rankles me to have to pay extra for the card data each year.