How do you import data into excel from a text file into rows and columns?
1 2 3
4 5 6
7 8 9
etc.
I will end up with about 550 rows I think. So my question is how do you get the data to go to the next row after every 3 numbers? I have tried porting it into excel, and I can only get one long row with each data point in its own column (like 550 columns which doesn't do me any good). Can anyone help?
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$5 Answers
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
http://renadexwarning.com/
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$http://office.microsoft.com/en-us/excel-help/text-import-wizard-HP010102244.aspx
if your looking for office 2007 then this would help you:
http://www.howtogeek.com/howto/microsoft-office/import-text-into-excel-2007/
step 1: select the text your need to change to excel, back up the text in case some thing goes wrong (go to file -> open -> select the text file)
step 2: select delimited and start import from 1 row (this option will be my default)
step 3: you will have option to separate or in other words to identify columns. select the one which best suites you purpose. you will have other option when you can set manually. a preview will be at the bottom so there will be no problem.
step 4: last will be data column, the final touch to arrange your separations. and click on finish.
your file many not exactly look the way you want, few chances will make it fine. its a computer and not the human being to interpret exactly.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$if you use ms excel 2007,
select all your data
click menu "DATA" then in ribbon click "text to column"
click delimited and next
and chose space, finish. you will get 3 column after that.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
Is there a way I can do it directly in Excel? Someone told me it was possible but I couldn't figure it out. I would prefer not to download another computer program if I don't have to.