I have used the Excel functions LEFT, MID, and RIGHT to dissect cells. However ... To transform data into a usable format, we can use TEXTSPLIT. TEXTSPLIT has six arguments, but only two are required.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback