|
|
#1
03-23-2024, 03:55 PM
|
|||
|
|||
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode