SPLIT: How to Count Non-Empty Cells in Google Sheets

Use SPLIT to count non-empty cells in Google Sheets. Complete tutorial with syntax and examples.

Syntax

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

How to Count Non-Empty Cells

Divides text around a specified character or string and puts each fragment into a separate cell. To count non-empty cells, combine SPLIT with the right arguments for your dataset.

Expert Tips

Google Sheets exclusive. Great for parsing CSV data, addresses, names.

Get a Free Quote →