How to do a Multiple Text Split Using MID function
Did you know the MID function accepts array constants at the start of the numbers argument and the number characters?
=MID(D5:D10,{4,14},{5,99})
See more examples from the discoverer of this Frédéric LE GUEN
#excel #exceltricks #exceltips