Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Special Paste Error...Data pastes into one column
I have this problem with a couple of my computers here on site. I will copy
some information from database that is web based and I will paste it using Special Paste, Select text and OK. Now it will normally paste the data into individual columns, but in this case it will paste all of the data into one column. I will go to another computer pull the data from the same page and special paste it. It will correctly paste it into their own individual columns. Any clues... Thanks... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Special Paste Error...Data pastes into one column
Excel normally pastes without parsing but if, in the current Excel session,
there are been a parsing into column with the Text Import Wizard (or Data, Test to Columns) then paste parses the same way. When you do not get the parsing you want you should just select the range of data and do a Data, Text to Columns, picking your delimiter, etc. You'll probably find that further pastes during that Excel session parse automatically. -- Jim "School" wrote in message ... |I have this problem with a couple of my computers here on site. I will copy | some information from database that is web based and I will paste it using | Special Paste, Select text and OK. Now it will normally paste the data into | individual columns, but in this case it will paste all of the data into one | column. I will go to another computer pull the data from the same page and | special paste it. It will correctly paste it into their own individual | columns. Any clues... Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 -- Copying a formula to Paste Special into column cell | Excel Discussion (Misc queries) | |||
I cut and paste a pic & it pastes somewhere else in the doc, why? | Excel Discussion (Misc queries) | |||
Special paste column widths is not coming up in Excel 2007? | Excel Discussion (Misc queries) | |||
When paste special links the file name gives error | Excel Discussion (Misc queries) | |||
Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) |