#1
|
|||
|
|||
Cut/paste into Excel
I would like to be able to copy some data from a text file and paste it into Excel 2010. The data in question is a small number of single digits and I would like each one to go into a separate column.
To test this, I created a simple test string, such as “1 2 3 4”, but when I copied/pasted it into Excel, all of the characters went into one cell. I tried replacing the spaces with tabs and commas, but that did not help. I checked Control Panel->Regional Settings->Additional Settings and see that List Separator is a comma. I am not sure what to try next. Any suggestions? |
#2
|
||||
|
||||
In your text editor enter value and hit "Enter" after each value
Copy paste the column to excel. Each value know has its own cell
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
The simplest way (as I haven't Excel available currently, I'm not sure how exactly all steps are done, so maybe you are to adjust somewhat):
Open a new instance of Excel; From this instance, select Open, set the file type as Text File, and open your text file; A window is opened, where you can determine the delimiter between columns (comma, or Tab, or Space, or whatever). You also can determine the format of every column you read in (General by default, or Text, or Numeric, or Date, ...). Set your preferences and open the text file in Excel; In case your table you want to copy the data from text file into is not opened jet, open it; Copy data read from text file into your table (I advise you use PasteSpecial>Values for this, unless you have set all column formats properly in read-in table), After data are sucessfully copied into your table, you can close the instance of Excel, used to read text file in, without saving it. |
#4
|
|||
|
|||
Pecoflyer - you are correct, but I want the values in a single row, not column
ArviLaanemets - I think you missed the point - I want to cut-n-paste, not open a file |
#5
|
|||
|
|||
Quote:
But you missed the point also - my post was not about 'cut-n-paste', but about getting data from text file into excel table! Who cares how this is done, when it is done? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Paste into Excel without Excel doing ANY re-formatting | Lebber | Excel | 20 | 07-08-2016 12:32 AM |
VBA to paste from excel onto new page | VincentBrown | Word VBA | 1 | 06-01-2015 09:14 PM |
Paste special an Excel range into Outlook as an Excel Worksheet | charlesh3 | Excel Programming | 3 | 02-04-2013 04:33 PM |
Paste Excel Link As | tphillippe | PowerPoint | 1 | 11-26-2009 05:54 PM |
Paste chart from Excel | bielak01 | Word | 4 | 04-29-2009 02:42 PM |