EXCEL

google sheets select item from split

# Basic syntax:
=INDEX(SPLIT("text_to_split", "delimiter"), row, column)
# Where:
#	- text_to_split is the text you want to split (can reference a cell)
#	- delimiter is the delimiter by which to split the text
#	- row, should be 0
#	- column, 1-indexed split element to return