Excel Comparison
TEXTJOIN vs CONCAT in Excel and Google Sheets
TEXTJOIN skipped or kept a blank: SKU-101,Widget,12.50 vs a doubled comma. CONCAT of two cells worked; CONCAT of the range returned #N/A.
#text
6 tutorials tagged “text”.
Excel How-to
Extract Text Between Two Characters in Excel and Google Sheets
MID and FIND pulled 12.50 from between $ and a space, and 103 from between brackets. TEXTBEFORE was #NAME? here; a loose regex returned start, not hello.
Excel Comparison
SUBSTITUTE vs REPLACE in Excel and Google Sheets
SUBSTITUTE changes text by value and instance; REPLACE changes a run of characters by position. Tested on banana and SKU-103; SUBSTITUTE is case-sensitive.
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.
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 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.