Forum Discussion

CSM_G's avatar
CSM_G
Copper Contributor
Feb 03, 2021

formula or script to change 'space delimited' rows to column separated

looking to see if anyone knows how to take a long row of data separated by spaces and convert that data into individual columns per row.

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    CSM_G On the Data ribbon, find "Text to columns". Step through the wizard and chose a space as the delimiter.

Resources