Google Sheets - Separate or Split Text on Comma, Space or Other Delimiter

When you get a list of values that are separated by comma, semi-colons or other delimiters, you might want to separate the values into it's own cell whether it's across columns or down the rows. In Google Sheets this video will cover two ways to do this; one with the text to column command in the file menu and the second with the SPLIT function.