Text
Clean, split and convert text in Google Sheets: hidden spaces, text before or after a character, SPLIT and numbers stored as text.
-
Split Text into Columns or Rows in Google Sheets (and the SPLIT Traps)
SPLIT breaks a cell into pieces at a delimiter and spills them into the cells to the right. It looks simple, and with =SPLIT(A2, “,”) on clean data it is.…
-
Remove Extra Spaces in Google Sheets (When TRIM Doesn’t Work)
TRIM removes spaces at the start and end of a cell and turns runs of spaces in the middle into one. For text you typed yourself, that is enough. For…
-
Extract Text Before or After a Character in Google Sheets
Pulling out the part of a cell before or after a character is one of the most common text jobs in a spreadsheet: the name before the @ in an…
-
Convert Text to Numbers in Google Sheets: What VALUE Can and Can’t Read
A number stored as text looks like a number, but most functions treat it as words. The dangerous part is that they rarely complain. In our test, three cells holding…