Split Text to columns

Hi All
 
I wonder if you could help with a query that we are facing. We have a binary file that previously staff members were able to open in notepad and then copy the data to Excel. They were then able to format it so that it was usable in Excel.


We have tried to do this in Google sheets by opening the document in Text editor and pasting it into Google Sheets, but the formatting doesn't seem to come out the same.  This is how we would like it to come out when we do a fixed text to column This was done on the Excel application
gansowolabi_0-1632761300126.png

 

 

This is how the same data looks in Google Sheets

 

gansowolabi_1-1632761391436.png

 

0 5 425
5 REPLIES 5
Top Labels in this Space