How to paste data into excel?

I need to paste a lot of data (about different rows) into excel. When I do this though, it puts everything from one row into a cell. It will take me hours to move all this about, is there anyway I can copy the data across so it goes into a table with rows and columns, rather than each row in one cell and no columns?

✅ Answers

? Favorite Answer

  • You have to do a bit of work first.

    Each field or row must be delimited. Say you have three fields (rows):

    name

    address

    country

    You delimit them by using a ” or a ; like this

    name;

    address;

    country;

    it can also appear like this:

    Tom;home;Australia;jenny;not home;England;sue;nearby;America

    There are various ways you can add delimiters to large text files, but you’ll have to experiment or do everything by hand. Some good text editors will allow you to search and replace a line feed (carriage return) with a delimiter. Unfortunately I can’t recommend one from the top of my head.

    If you have three fields in Excel, when you import from your standard delimited text file, it will ask for the delimiter type (;) and enter the first three items in name, address, country, then the next three into name, address, country until it reaches the end.

    I hope that makes sense. Just remember that there must be a pattern. Three items for each line or row of cells, or whatever.

    Good luck.

  • You can import data from a word pad text file with tabs being used to separate the information on each row.

    See also  Can someone please send me an Activation Code for AutoCAD 27?

    Open up a new excel file, go to data > import external data > import data

    Find your file (remember to change files type box to show “All files”

    Select file > open > an import wizard box will appear to help you.

    Leave default settings for delimited and go click on finish and ok.

    This will then import the lot onto separate columns and rows.

  • Copy the whole worksheet not just the lines of text/data.

  • Other Related Questions

    Learning Visual Basic ?

    Answers Favorite AnswerTry using "System.Diagnostics.Process. GetProcessesByName( "iwmp" ).Length > " for your check.

    Microsoft Office word Fast answer needed its urgent?

    Answers Favorite AnswerTry this:http://www.techsupport.com///microsoft-wo...Here is another thread re: the same issue with instructions:http://www.pcreview.co.uk/forums/modification-not-...http://www.techsupport.com///microsoft-wo...http://support.microsoft.com/kb/http://answers.microsoft.com/en-us/office/forum/of...

    Can I download a whole city android google maps?

    Answers Favorite Answer:) Yes!!!Interesting question. I wonder why it has blocked in this way especially considering that Google Earth is very detailed and has good maps of Israel.

    What is meant by ROM ? Explain in simple but elaborate terms.What about mobile ROM’s?

    Answers Favorite AnswerHi Diva below is a link that will give a simple answer.http://wiki.answers.com/Q/What_does_ROM_stand_for_...Hope this helps.Source(s): Experience and wiki answers.ROM is Read only memory. i.e data can write only once.There two types of ROM..ROM.PROMThe difference between ROM and PROM.that is ROM is programmed during manufacturing it means data stored by manufacturing company.PROM is blank memory that a user programmable memory.user can store content on PROM.both ROM and PROM are Read only memory Data can write only once.and its not possible to write so many time.Memories of PROM and ROM are Non-volatile in nature. Its that stored informations can retain even power goes off.

    See also  How can I create an Adobe Flash Starfield which changes based on user control?

    Leave a Comment