ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I maintain columns when I copy JMP data into Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/89944-how-do-i-maintain-columns-when-i-copy-jmp-data-into-excel.html)

MPTfan

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.



All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com