SPLIT()

Description

Divides text around a specified character or string, and puts each fragment into a separate cell in the row.

How To Use in Sheets

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

External Links

Word Count, Unique Word Count, Most Popular Words - Google Sheets

Learn how to count words, get unique word count, calculate word frequency & get a list of most popular words with their counts in a Google Sheets spreadsheet.