Question Locked

Excel: Please how to i arrange and transfer this data into spread sheet.

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

1. John blue, 12 pop road, well, devon, london.
2. Adam blue, 13 pop road, well, devon, london
3. Carlos blue, 14 pop road, well, devon, london
4. Luke blue, 15 pop road, well, devon, london
5. Dean blue, 16 pop road, well, devon, london
6. James blue, 17 pop road, well, devon, london
7. Joe blue, 18 pop road, well, devon, london
8. Pat blue, 20 pop road, well, devon, london

If you try copy and paste, you will find out that it never fit the data page.

8 replies

by robo_dev

Pretty much copy and paste.

If this is a question about duplicates, then perhaps the AbleBits 'Duplicate Remover for Excel' add-in is what you need.

by markinze

1. John blue, 12 pop road, well, devon, london.
2. John blue, 12 pop road, well, devon, london
3. John blue, 12 pop road, well, devon, london
4. John blue, 12 pop road, well, devon, london
5. John blue, 12 pop road, well, devon, london
5. John blue, 12 pop road, well, devon, london
5. John blue, 12 pop road, well, devon, london
5. John blue, 12 pop road, well, devon, london

by oldbaritone

Use Notepad and paste the data into a file.
When you save the file, name it with an extension of .TXT - which is the default for Notepad. (like MYDATA.TXT)

Then on the Ribbon use "Data - Import Text". When prompted, the text is "Delimited", click "Next", and check "Comma" in the list. (If you copied the line numbers and want them to import properly too, also check the "Other" check box and put a period (.) in the text box next to Other:.

Then click "Finish" and "OK" (assuming you had the cursor in the top-left corner of the place you wanted the data to be put.)

Happy Homework. It's Friday and I'm feeling generous.

by a.portman

I do this all the time. Comma Delimited Text is your friend.

by draco vulgaris

If you have eight or eighteen records, you sit in front of your computer and type.

If you have 18,000 records, IN MACHINE READABLE FORM, you write a program
to translate to a format readable by the spread sheet.

You didn't say which spreadsheet you are using. Without that information, it's going to be difficult for anyone to give you detailed instructions!

If you care to tell us what software you are using, NAME AND VERSION, we may be
able to give you more explicit directions.

You might also read: http://catb.org/esr/faqs/smart-questions.html

This discussion is closed to new replies.