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
On this page of the site you can watch the video online How to do a Multiple Text Split Using MID function with a duration of hours minute second in good quality, which was uploaded by the user CrispExcel Training & Consulting 21 October 2024, share the link with friends and acquaintances, this video has already been watched 149 times on youtube and it was liked by 7 viewers. Enjoy your viewing!