I have a spreadsheet with text in one column that also has a number or series of numbers at the end of each line. I want to be able to extract the number or series of numbers individually into each of the columns to the right. When there are more than one number, there can be as many as a series of 6 numbers. On the
The example of what I am looking for is to extract the 919 from line three.
to extract the (726, 30, 36, 17, 97, 31) from line four into six columns.
Column1 |
New York (A) - Top of 1st |
Zac Gallen pitching for Boston |
Bryan Reynolds flied out to right. (919) |
Charlie Blackmon flied out to deep right. (726, 30, 36, 17, 97, 31) |
Bo Bichette singled to left. (379, 41) |
Jeimer Candelario flied out to center. (968) |
0 runs, 1 hits, 0 errors |
Boston - Bottom of 1st |
Max Fried pitching for New York (A) |
Harold Ramirez struck out swinging. (874) |
Jose Ramirez singled to left. (245) |
Ronald Acuna Jr. walked, Jose Ramirez to second. (244) |
Aaron Judge homered to right center (438 feet), Jose Ramirez scored, Ronald Acuna Jr. scored. (144) |
Wilmer Flores grounded out to third. (296) |
Jorge Soler popped out to catcher. (527, 13, 5) |
3 runs, 2 hits, 0 errors |
New York (A) - Top of 2nd |
Zac Gallen pitching for Boston |
Joey Meneses singled to right. (163) |
Yan Gomes struck out swinging. (230) |
Whit Merrifield doubled to left center, Joey Meneses scored. (932) |
Jake Meyers safe at first on error by first baseman Harold Ramirez, Whit Merrifield to third. (083, 3, 15) |
Elvis Andrus flied out to left, Whit Merrifield scored. (495, 20) |
Bryan Reynolds grounded out to first. (927) |
The example of what I am looking for is to extract the 919 from line three.
to extract the (726, 30, 36, 17, 97, 31) from line four into six columns.
Last edited: