Welcome, Guest. Please login or register.

Login with username, password and session length

 
Advanced search

1411512 Posts in 69376 Topics- by 58430 Members - Latest Member: Jesse Webb

April 26, 2024, 11:03:59 PM

Need hosting? Check out Digital Ocean
(more details in this thread)
TIGSource ForumsDeveloperTechnical (Moderator: ThemsAllTook)inserting text from word into excel
« previous next »
Pages: [1]
Print
Author Topic: inserting text from word into excel  (Read 1060 times)
AuthenticKaizen
Freeware Ninja
Level 10
*


*Prestige Worldwide*


View Profile WWW
« on: February 12, 2009, 11:39:04 AM »
hello everyone,
i just wanted to insert a list from a word document into excel...
but it inserted the whole list into one cell...straight into one epic line!

is anyone experienced in this and can tell me what to do that each line will be inserted into a new row...
without doing it manually for every single line...
Logged
PixelProspector.com - the indie goldmine + Marketing Guide for Indie Game Developers             
“Knowing is not enough, you must apply; willing is not enough, you must do.” (Bruce Lee)
Gold Cray
Level 10
*****


Gold Cray


View Profile WWW
« Reply #1 on: February 12, 2009, 12:03:04 PM »
You ought to be able to separate columns with tabs and rows with newlines. If that doesn't work, you can make a test file using commas to separate columns and newlines to separate rows, save it as a .csv, and import it into excel.
Logged
AuthenticKaizen
Freeware Ninja
Level 10
*


*Prestige Worldwide*


View Profile WWW
« Reply #2 on: February 12, 2009, 01:27:28 PM »
allright. it works.  Smiley
thanks  Gentleman
Logged
PixelProspector.com - the indie goldmine + Marketing Guide for Indie Game Developers             
“Knowing is not enough, you must apply; willing is not enough, you must do.” (Bruce Lee)
Pages: [1]
Print
« previous next »
Jump to:  

Theme orange-lt created by panic