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

Copper Contributor

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

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