#textsplit

Split Text by Delimiter in Excel and Google Sheets

Split a cell on commas or spaces with SPLIT in Google Sheets. TEXTSPLIT was #NAME? here; leading zeros became numbers, and a blocked spill is #REF!.