CODE EXAMPLE FOR EXCEL

google sheet split text

# 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