How do I maintain columns when I copy JMP data into Excel?

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to stack column data in Access? 4
Copy data from unlocked cells 3
How do i copy columns of data in notepad into excel? 1
transpose 1 column of 100 items to 10 x 10 array 2
Pivot table data layout - columns to rows 1
How do i copy columns of data in notepad into microsoft excel? 3
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) 2
copy outlined data in excel 1

Top