Hello,
I have a string of text in a cell that I need to separate into multiple cells, Text to Columns will work however I need a formula to do this as I don't want to have to break this out every time I refresh the data.
I don't think LEFT, RIGHT, or MID functions will work since the number...