Data handling in Excel Worksheets.
I have text data which I want to import into Excel.
When I import via the get external data menu I get this result.
To get the data into different columns I then try the text to columns but all that does is give me preceding zeros.
How do I get this result?