Macro required to separate numbers from one column into 4

Below is a list of coordinates (ID#, easting, northing, level). When I paste this into excel it all ends up in column A. I need to separate these so the ID (e.g. 1A.1) is in column A, the easting (e.g. 232443.508) in column B, the northing (e.g. 333090.416) in column C and the level (e.g. 81.372) in column D. Obviously I can go through and do this manually but that is taking time and the list of coordinates could run into the thousands.

Any help much appreciated.

Thanks,

Data below:

1A.1 232443.508 333090.416 81.372
1A.2 232463.683 333095.373 81.534
1A.3 232477.757 333094.987 81.574
1A.4 232483.862 333094.475 81.419
1A.5 232503.775 333088.424 81.470
1A.6 232501.590 333022.332 81.524
1A.7 232499.406 332956.251 81.747
1A.8 232497.222 332890.148 81.624
1A.9 232477.057 332885.488 81.718
1A.10 232468.025 332885.452 81.885
1A.11 232457.265 332885.919 81.829
1A.12 232436.955 332892.140 81.779
1A.13 232439.138 332958.210 81.854
1A.14 232441.323 333024.327 81.637
1A.15 232463.497 333089.755 78.724
1A.16 232483.786 333089.084 78.724
1A.17 232481.601 333022.992 78.835
1A.18 232479.417 332956.900 78.945
1A.19 232477.232 332890.808 79.056
1A.20 232456.944 332891.479 79.056
1A.21 232459.128 332957.571 78.945
1A.22 232461.312 333023.663 78.835

Hi Glen,
Can you elaborate on your post a bit more please?
Thank you

Hi
For sure what MR. Glenn suggested is the best way
But for what ever
Try

Please Login or Register  to view this content.

Originally Posted by Glenn Kennedy

Just do what it says.... Follow the instructions.

After they're in a single column.

Data: Go to ribbon Tab "Data"
Text to columns: Click on Text to columns.
Delimited: Select Delimited.
NEXT: Click Next
Space: select space as the delimiter
Finish: Finish click finish.


Err.... that's it. Done.

Class thank you!