I have used the Excel functions LEFT ... TEXTSPLIT is a very useful function for breaking down text cells that contain different lengths of text and delimiters. It can be used in several ways, and ...