Any way to import large text file of numbers without Excel splitting numbers?

Hi all,

I'm not very experienced with Excel and am having a huge problem. I have a text file with rows and columns of numbers ranging from 1-4 digits that I'd like to import/copy into Excel with each number being in its own cell. But whenever I copy/try to import, Excel splits all of the 3-4 digit numbers up into single digit numbers. The text file has 10,000+ columns (each number occupies two columns so I have half of that amount in numbers) and 300+ lines.

Is the file simply too large for Excel to handle or is there a way I can do this? Any help would be appreciated!

Thank you for the reply,

Here is a sample of some complete lines from my text file. I want the Excel sheet to look exactly like the text file with the only difference being that each number is within a single cell. Whenever I try to import or copy, Excel shows many more rows than the text file has (10 rows in my file, 20+ showing in Excel). Additionally, none of the triple digit numbers appear (they usually get split up into a single and a double digit number in separate cells), as you can see with the first number, 912 getting split into 9 and 12.

So I'd expect to see ten rows in my Excel sheet, with the first cell of the first line containing the number 912.

I may be over-complicating a simple explanation. I don't want anything about the text file to change except that I want each number (i.e., 912, 10, 11, 9) to be in its own cell. I want the same number of rows as are in the text file with the corresponding numbers in each row. To visualize it, I could print out the text file in its current layout and draw a box around each number representing cells in Excel.

Here's what I want it to look like. This is just a sample of the first five numbers from each row. In reality I need the rest of the rows to be there too. I did this manually.

Key points:

-912 in text file turns into 912 in its own cell in Excel, NOT 9 and 12, or 9, 1, and 2, or 91 and 2.
-Ten rows in text file turns into ten rows in Excel

Here is what I see the text file as:

There are ten lines/rows. I'd like to preserve that layout.

The file is originally from an energy technology laboratory and represents voxel coordinates of a rock fracture that I will need to run a simulation on for pressure loss predictions. I am still getting the hang of the computational fluid dynamics software that I'm using so my professor advised that I don't tackle every point/number but rather average groups of them together to make it simpler. So I've been averaging 16x17 blocks of numbers by copy and pasting individual fragments of text lines into Excel but its tedious to the point where there certainly must be an easier way.

So the method of importation depends on the whole file?

I suppose I could use some math to alter the single row to suit my calculations, and I think that'd be easier than what I'm currently doing.

But, if you look at my uploaded file called "Sample Screenshot," there are only 10 lines. Could it be that my version of Notepad is simply choosing to display the text the way that I see it and that different programs will show it differently? That seems to be the case since you see 25 lines, shg.

Also, I was previously unfamiliar with terms like delimited and linefeed and they make sense to me, but how do you "see" lines terminated by a linefeed? And how do you change that?

The file is originally from an energy technology laboratory and represents voxel coordinates of a rock fracture that I will need to run a simulation on for pressure loss predictions. I am still getting the hang of the computational fluid dynamics software that I'm using so my professor advised that I don't tackle every point/number but rather average groups of them together to make it simpler. So I've been averaging 16x17 blocks of numbers by copy and pasting individual fragments of text lines into Excel but its tedious to the point where there certainly must be an easier way.

I just downloaded Notepad++ and made the data into a single row like someone mentioned doing earlier. I could do with that, I'd just have to do a bit of tedious counting and math but compared to my previous method it's much better. But now the fact that different text programs display the same file differently makes me ask a question that I'll have to raise to my professor tomorrow.

Thanks for the help everyone!