Forum Discussion
LouisHark
Apr 04, 2020Copper Contributor
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...
SergeiBaklan
Apr 08, 2020Diamond Contributor
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.