Check out, check in, or discard changes to files in a SharePoint ...
When you have the file checked out, you can edit it online or offline, and save it—multiple times, if necessary. When you finish editing and check the file back into the library, other people can see your changes and edit the file, if they have permission.
TEXTSPLIT function - Microsoft Support
Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function. =TEXTSPLIT (text,col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
TEXTBEFORE function - Microsoft Support
Returns text that occurs before a given character or string. It is the opposite of the TEXTAFTER function. =TEXTBEFORE (text,delimiter, [instance_num], [match_mode], [match_end], [if_not_found]) The TEXTBEFORE function syntax has the following arguments: text The text you are searching within. Wildcard characters are not allowed.