Forum Discussion
CSM_G
Feb 03, 2021Copper Contributor
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_EekelenPlatinum Contributor
CSM_G On the Data ribbon, find "Text to columns". Step through the wizard and chose a space as the delimiter.