Forum Discussion

TOM EVANS's avatar
TOM EVANS
Copper Contributor
Sep 19, 2018

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.

excel
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 20, 2018

    Mr. Evans

    your attached sample - sorry to say, I can not understand.

    but, based on your query I made sample as attached

    see if you can make something out of it

    thanks..

     

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 20, 2018

    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?

    • TOM EVANS's avatar
      TOM EVANS
      Copper Contributor
      Sep 20, 2018

      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. 

Resources