Quote:
Originally Posted by StLee
It was easier just to change the schedule. I am using the =SUBSTITUTE feature to change them all. Do you have a suggestion for a better function for an intermediate Excel user? It took me about an hour to move every game 14 days later, but could I have been more efficient?
I decided to just make the schedule a 1-167 schedule instead of the -13-153 schedule I was going to attempt.
|
It’s hard to explain quickly over text, but you’d want to first split the data into multiple columns using the “text to column” feature on the data tab. Then once you isolate the days into a single column, you can create a new column with a formula that adds 14 to every number. Paste that new column over the old column as text and there you have it