SPLIT and JOIN practice in Google Sheets
Cut text into cells with SPLIT and put a list back together with JOIN.
- 1Split a name with SPLITIn B2, use SPLIT to split the name in A2 at the space, into first and last name.
- 2Split a date into numbersPremiumIn B2, use SPLIT to split the date text in A2 at the dashes into year, month and day.
- 3Join a list with JOINPremiumIn B2, use JOIN to turn the tags in A2:A4 into one text, with a comma and a space between them.