Excel How-to
Keep Leading Zeros in Excel and Google Sheets
Store 001 as text, or pad with TEXT(n,"000"). VALUE and SPLIT turned 001 into 1 in this Google Sheets test; LEN confirmed when the zeros were kept.
#split
4 tutorials tagged “split”.
Excel How-to
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!.
Excel Error fix
#REF! Error in Excel and Google Sheets: Causes and Fixes
#REF! means a reference is invalid. Tested: a VLOOKUP column too far right, INDEX off an array, INDIRECT, OFFSET off the grid, and a blocked SPLIT.
Excel How-to
Split Full Names into First, Middle and Last Name in Excel & Google Sheets
Split first, middle and last names in Excel and Google Sheets: first/last-word formulas, comma-style lists, and why titles and suffixes still need a check.