Importing a CSV/DAT file

[CaptainVolvo]

Hi all,
I am currently trying to create a sheet where i can import a CSV without having to run through all of the wizard screens.

Scenario:
Each week i receive a .dat file which contains information seperated by spaces i.e. 15/02/2018 10:20 1598465 712.84 -82.63.
This information will be placed into columns A to E and a formula added to column F that will format the information ready for loading into an application i.e. ("1598465""15/02/2018""10:20""712.84""-82.63")

I would basically like to use this spreadsheet as a template and any new .DAT files can be easily entered into the spreadsheet without having to go through the wizard each time.

I hope that makes sense.
Thanks in advance.

[Olly]

Power Query (free add-in for 2010) would be perfect for this.

If you attach a sample .DAT file, and an example of what your output looks like, then I can write the query.