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
Watch video How to do a Multiple Text Split Using MID function online without registration, duration hours minute second in high quality. This video was added by user CrispExcel Training & Consulting 21 October 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 115 once and liked it 7 people.