CODE EXAMPLE FOR EXCEL

google sheets split cell by delimiter

# Basic syntax:
=SPLIT("text_to_split", "delimiter")

# Note, to access a given value after splitting the text, use index like:
=INDEX(SPLIT("text_to_split", "_"), 0, 2) # returns to