How do i split a massive list of values into individual cells down a column?

Hey everyone first post so i apologist for anything wrong with it.

I have an issue with being able to process my data i have a text file in notepad that lists a massive amount of values (enough for excel to process if they are listed down a column but not across a row) each separated by a space. As an example here is a small portion of the data.

81768102 191193210 386225426 110858190 393958997 21773704 22450052 70617438 843133051 103582830 370163346 819494826 109538724 846339187 19638405 50748904 476397524 128490548 134215188 252862729 387318907 82658728 15822910 199255054 172623979 59872284 773581712 124854321 547098635 604524102 45265054 203132867 225629848 215828319 14779508 300950341 715797961 329121584 366323012 583555062 917794380 216847744 784432795 606179111 537865871 500392632 37701513 830010548

I know how to import this as text but i can only wither get it all in one cell or across the 1st row. The first row can only display about 16000 values and that isn't enough for my end product to be accurate enough.

So is there any way to import the text file and have it formatted so a each new value has its own row? For example...
81768102
191193210
386225426
110858190
393958997
21773704

Or is there anyway to get the data from my already imported giant A1 cell into the above format?

Cheers

Edit: added an example of how it looks and how i want it to look. This is how it looks when i open the txt file containing my data in a way that all values stay in the excel sheet. As well as this there is an example of how i want it or rather need it to look.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Assuming your data is in A1 then in B1 copy paste below and drag down
=TRIM(MID(SUBSTITUTE($A$1," ",REPT(" ",255)),((ROW(A1)-1)*255)+1,255))+0

*corrected

Hi i just tried what you said to do and it didn't seem to help check the attachment to see what happened.

Edit: I also tried the corrected version, same result.

I think it is exceeding the character limit and throwing the error ! may need to use VBA solution for the same!

In B1 Cell of your Post #4 File

=IFERROR(TRIM(MID(" "&$A$1&" ",FIND("^",SUBSTITUTE(" "&$A$1&" "," ","^",ROW(A1)))+1,FIND("^",SUBSTITUTE(" "&$A$1&" "," ","^",ROW(A1)+1))-FIND("^",SUBSTITUTE(" "&$A$1&" "," ","^",ROW(A1)))-1)),"")

Drag it down...

=MID($A$1,FIND("@",SUBSTITUTE(SUBSTITUTE(" "&$A$1," ","@",ROW(A1))," ","@",ROW(A1))),FIND("@",SUBSTITUTE(SUBSTITUTE(" "&$A$1," ","@",ROW(A1))," ","@",ROW(A1)),FIND("@",SUBSTITUTE(SUBSTITUTE(" "&$A$1," ","@",ROW(A1))," ","@",ROW(A1)))+1)-FIND("@",SUBSTITUTE(SUBSTITUTE(" "&$A$1," ","@",ROW(A1))," ","@",ROW(A1))))+0

try this in B1 and drag down hope this helps

drag the formula down in attachment

try formatting the column with scientific numbers.