I have used the Excel functions LEFT ... To transform data into a usable format, we can use TEXTSPLIT. TEXTSPLIT has six arguments, but only two are required. Let’s focus on those two. The first ...