The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
For example, =MID(“apple”,2,3) returns “ppl”.
MAC address format
To format a MAC address string without delimiters to a MAC address separated by a colon (:) or hyphen (-), you can use a formula based on the TEXTJOIN, MID, and SEQUENCE functions. In the example shown, the formula in D5, copied down, is: =TEXTJOIN(C5,1,MID(B5,SEQUENCE(6,1,1,2),2)) The formula returns the formatted strings as seen in column D.
