Forum Discussion
Text to Columns - Special delimiters
Hi, What delimiter should I use to parse this bulk data download using the Text-to-Columns function in Excel? My intended output is what is that which can be seen in cells H22-K22, which is dat...
1) It's not necessary to double click every cell, you may apply Wrap Text to entire range to check which cells are with line breaks
2) That could be tons of ideas what the delimiter is, better to check what it actually is with CODE() and MID() functions or some other way.