Forum Discussion
split cell to columns
I paste text into a cell and want to get text to column. The text expands into columns in the same row. How can I get the text into vertical columns.
Yes, it's not clear. Better to work with the source, not transpose text to columns results. It looks likes CSV string
a1,n1,a2,n2,a3,n3
is to be converted not to columns
a1|n1|a2|n2|a3|n3
but to two (or one?) columns like
a1|n1
a2|n2
a3|n3
And is the source only one CSV string or many of them?
That was the clue. I worked with CSV files in the past and expected the same results when I delimited text. The problem is the text was one string with no EOF at the end of the line. So it all went into one cell which expanded into one row. When I added the EOF to the text file where I wanted to start a new cell; it worked OK but I found it less cumbersome to CUT / PASTE from the expanded single cell/row.
Thanks to all.
