How to Combine, Split, and Format Text in Google Sheets
Stop doing this manually in Google Sheets.
In this video, I’ll show you a few quick text tricks that will save you time and make your spreadsheets way easier to work with:
Combine multiple columns into one
Split text back into separate columns
Use keyboard shortcuts to move faster
Fix text formatting (like ALL CAPS to proper case)
If this helped, make sure to save it for later and check out my channel for more simple, practical spreadsheet tips.
FORMULAS:
=A2&” “&B2&” “&C2
=SPLIT(D2,” “)
=PROPER(I2)
=UPPER(I2)
=LOWER(I2)
KEYBOARD SHORTCUTS:
CTRL+SHIFT+dwn : select column
CTRL+SHIFT+:rt select row
CTRL+C: copy
CTRL+V : paste