Splitting

LEFT(string, length)

You can use the LEFT function to return a number of characters from the left of a string.

RIGHT(string, length)

You can use the RIGHT function to return a number of characters from the right of a string.

MID(string, start [,length])

You can use the MID function to return the text which is a substring of a larger string.
The first character position is 1.

SPLIT(expression [,delimiter] [,limit] [,compare])

You can use the SPLIT function to return an array containing a specified number of substrings (Variant).

Splitting at the last backslash

Splitting at the first occurrence

Splitting at the last occurrence

Splitting at the nth occurrence

Splitting between two search terms

Splitting a comma separated list

Looping through the array.

Splitting a comma separated list

Using a For Each loop.

Splitting a comma separated list

Using string manipulation.