Text Manipulationbeginner
Combine address parts into one field with CONCAT
=CONCAT(A2,", ",B2,", ",C2," ",D2)
Text Manipulation
Text Manipulation formulas
Extract, combine, clean, and reformat text values from any cell or column.
Text Manipulationbeginner
Convert text to proper case with PROPER
=PROPER(A2)
Text Manipulationbeginner
Count characters in a cell with LEN
=LEN(A2)
Text Manipulationintermediate
Extract a substring from the middle with MID
=MID(A2,5,3)
Text Manipulationbeginner
Extract the first N characters with LEFT
=LEFT(A2,3)
Text Manipulationbeginner
Extract the last N characters with RIGHT
=RIGHT(A2,4)
Text Manipulationbeginner
Replace specific text with SUBSTITUTE
=SUBSTITUTE(A2,"-","")
Text Manipulationbeginner
TEXTJOIN a column into one cell
=TEXTJOIN(", ",TRUE,A2:A20)
Text Manipulationbeginner
TEXTJOIN for full name building
=TEXTJOIN(" ",TRUE,A2:C2)
Frequently asked questions
Can CONCAT handle an entire column range?
Yes — CONCAT(A2:A20) joins all non-empty values with no delimiter. Use TEXTJOIN when you need a delimiter between each value.
How do I convert text to ALL CAPS instead?
Use UPPER(A2) to convert to all uppercase, or LOWER(A2) for all lowercase.
How do I count only letters, not spaces?
Use LEN(SUBSTITUTE(A2," ","")) to strip spaces before counting. For a true letter-only count, you would need a more complex approach with SUMPRODUCT.
How do I use MID when the start position varies?
Combine MID with FIND to locate a delimiter dynamically — for example, =MID(A2, FIND("-",A2)+1, 3) extracts 3 characters starting right after the first hyphen.