Question : google sheets select item from split
Answered by : charlesalexandre-roy
# 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
Source : https://stackoverflow.com/questions/32307788/get-first-item-from-split | Last Update : Mon, 04 Jul 22