| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I maintain columns when I copy JMP data into Excel?
A question for those who use JMP from SAS, and Excel.
In JMP 5, I could (and frequently did) copy tables, or rows or columns of tables, directly into Excel. Now I cannot. The column separator information is lost. I can copy columns of data from JMP 6 to Excel, but I cannot copy rows of data (since the column information is lost, all data in a JMP row is copied into a single cell in Excel). I believe part of the problem may be that JMP 6.0 stores data in Unicode format, unlike JMP 5. Does anyone know a workaround? (I have looked at help pages on JMP and Excel for about an hour with no resolution.) Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Copy and Paste Several Columns of Data into Excel... ? | Excel Discussion (Misc queries) | |||
| Create form to add data to Excel 40 odd columns | Excel Discussion (Misc queries) | |||
| Numbers/Text data missing from excel to excel query? | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
