SPLIT practice

SPLIT divides a text around a delimiter into separate cells, in Google Sheets. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

What people get wrong

INDEX(SPLIT(name, " "), 1) takes just the first name.

Google Sheets exercise that use SPLIT

• First name with SPLITLevel 5Pro

Often used together with: INDEX