Hello,
I have some cells that contain long comma-separated text like this in each cell:
Day0, Day 1,Day7, Day 15,Day30, Day 250,Day45, Day125
I want to make a formula that would dissect all components of the cell text (should be maximum 40) between commas and spill the resulting components horizontally. Additionally, it would be great to have the following features (as many as feasible )
1) uniform spelling of all components with 1 space in between "Day" and the number
2) typos in "Day" automatically corrected in the output spill
3) skip the components with missing number (so that they don't appear in the spilled row)
4) sort the spilled results with increasing number
I was having a hard time coming up with the function, so thanks for any input!
Thanks for any input!
I have some cells that contain long comma-separated text like this in each cell:
Day0, Day 1,Day7, Day 15,Day30, Day 250,Day45, Day125
I want to make a formula that would dissect all components of the cell text (should be maximum 40) between commas and spill the resulting components horizontally. Additionally, it would be great to have the following features (as many as feasible )
1) uniform spelling of all components with 1 space in between "Day" and the number
2) typos in "Day" automatically corrected in the output spill
3) skip the components with missing number (so that they don't appear in the spilled row)
4) sort the spilled results with increasing number
I was having a hard time coming up with the function, so thanks for any input!
Thanks for any input!