Now let’s use this function with rows. It works the same way, but instead of parsing across columns, it parses down rows. Figure E shows a simple array in B3 and the function =TEXTSPLIT(B3,,",") ...