Importing Files Into Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2988127%22%20slang%3D%22en-US%22%3EImporting%20Files%20Into%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2988127%22%20slang%3D%22en-US%22%3EI've%20got%20a%20question.%3CBR%20%2F%3E%3CBR%20%2F%3ELet's%20say%20I%20have%20a%20file%20name%2C%20for%20example%2C%20see%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E20211119%20RECEIPT%20GAS%20SHELL%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20I%20can%20import%20this%20file%20into%20Excel%20and%20have%20it%20auto%20fill%20into%20four%20columns%3F%3CBR%20%2F%3E%3CBR%20%2F%3Ei.e.%20Column%201%20ISO%20DATE%20YEARMONTHDAY%2C%3CBR%20%2F%3EColumn%202%20FILE%20CATEGORY%2C%3CBR%20%2F%3EColumn%203%20FILE%20SUBCATEGORY%201%2C%3CBR%20%2F%3EColumn%204%20FILE%20SUBCATEGORY%202.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2988127%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
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
1 Reply

@ljtetrick 

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