Hey I am a football coach we use excel to script our practices. I want our long script string to be broken up into separate columns.
Here is an example:
In excel I have: 1 split H Across 67 Hitch Rt
I want to split up the Formation (1 Split) the motion (H Across) the hole (67) and the play (hitch rt)
I realize this is pretty easy for one play but here is the catch. Our formation could be 1, 1 split, 1 wide, 1 tight, or 2, 7, 8 with either no word or the same word after it. Some plays have motions and some don't. If someone is willing to help me with this I could send you a file with our script in it.
Here is an example:
In excel I have: 1 split H Across 67 Hitch Rt
I want to split up the Formation (1 Split) the motion (H Across) the hole (67) and the play (hitch rt)
I realize this is pretty easy for one play but here is the catch. Our formation could be 1, 1 split, 1 wide, 1 tight, or 2, 7, 8 with either no word or the same word after it. Some plays have motions and some don't. If someone is willing to help me with this I could send you a file with our script in it.