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