Forum Discussion

Saikat755's avatar
Saikat755
Copper Contributor
Jan 02, 2020
Solved

Converting text to columns

I have a large data-set with fields that needs to be converted to columns; I have used Excel's "Text-to-Columns" feature using delimiters but there isn't any specific delimiter as mentioned in the op...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 02, 2020

    Saikat755 

    If you are on Windows select Other and Ctrl+J as delimiter.

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Jan 02, 2020

Hi Saikat755 

 

If your data is consistent then you may use 'Fixed Width' option as an alternative:

 

To remove extra lines just double click them and press Finish

Thanks

Tauqeer

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 02, 2020

    tauqeeracma 

    As side effect that won't remove line break character at the front of each next column

Resources