Hello -
I am importing a string of text into excel and want to break the text into multiple cells. I have an attachment with an example. Each place you see a comma I would like to have it placed into a different cell (ex, b1, c1, d1, etc). I was thinking of using the MID function but I am having trouble getting the number of spaces correct. I'm not sure if I'm using the function correctly or if their is some other formatting in the background that I'm not seeing.

Much Thanks in advanceBreak at Comma.xlsx