Copying data

  • Thread starter drizzle
  • Start date
  • #1
drizzle
Gold Member
366
57
does anyone know how to copy data from Notepad file [Text Document] into Excel? the data I need to copy is two columns of numbers, but when I copy-paste them they appear as one column, I just couldn’t manage to separate them [they are about 40 pages long:cry:]. anyone have any suggestion, thanks in advance.
 

Answers and Replies

  • #2
490
2
in Excel, go to Data->Import External Data->Import Data and select the text file. You can then choose delimmeters or spacing to import columns from the text file.
 
  • #3
drizzle
Gold Member
366
57
cheers, that'll save a LOT of time :biggrin:
 
  • #4
drizzle
Gold Member
366
57
Does anyone know how to extract data from a pdf file into an excel file? :biggrin:

There're limited choices of files where one can import data from, any idea anyone? Thanks in advance.
 
  • #5
2,685
22
There are a bunch of ways, your best bet is to download Nitro PDF pro trial (14 days) and that has a built in function to extract a PDF to Excel (or Word).

Aside from that you've only got other OCR software.

Both these methods work best when it is not a scanned PDF document.
 
  • #6
MATLABdude
Science Advisor
1,655
4
If the document isn't a scanned PDF, you can copy and paste the data into Notepad, where you'll probably need to do some formatting.
 
  • #7
drizzle
Gold Member
366
57
Cheers.
 

Related Threads on Copying data

  • Last Post
Replies
14
Views
5K
Replies
8
Views
1K
Replies
8
Views
1K
  • Last Post
Replies
3
Views
3K
Replies
31
Views
2K
  • Last Post
Replies
3
Views
2K
  • Last Post
Replies
9
Views
3K
  • Last Post
Replies
14
Views
2K
  • Last Post
Replies
4
Views
2K
  • Last Post
Replies
21
Views
10K
Top