Importing Files Into Excel

[ljtetrick]

I've got a question.

Let's say I have a file name, for example, see below:

20211119 RECEIPT SHELL

Is there a way I can import this file into Excel and have the file name auto fill into three columns?

i.e. Column 1 ISO DATE YEARMONTHDAY,
Column 2 FILE CATEGORY,
Column 3 FILE SUBCATEGORY 1

Thank you

[#2]

@ljtetrick 

Depends on your Excel version. You may use Power Query or From Text import Wizard using space as columns separator.