Re: Copying from Excel 97
- To: mathgroup@smc.vnet.net
- Subject: [mg11297] Re: Copying from Excel 97
- From: jgore@andrew.cmu.edu
- Date: Wed, 4 Mar 1998 01:39:51 -0500
- Organization: Carnegie Mellon, Pittsburgh, PA
I put the { 's and commas in excel before I copy. Put a column of
commas in between each column of numbeers. Put a column of { on the
left of the matrix. Put a column of }, on the right side (note the
comma ) Then put an extra { at the top left corner and an extra } at
the bottom right corner. Copy the whole thing into mathematica. You
could write a macro to do this for a selected region of cells.
-JG
--On Tuesday, March 03, 1998, 1:24 AM -0500 "Lawrence Walker"
<lwalker701@earthlink.net> wrote:
> Hi,
>
> When I try copying a block of values from Excel 97 to Mathematica3 I get
> a list of numbers with the first entry of each row running together
> with the last number from the previous row. As a result I have to
> manually enter spaces between the numbers.
>
> For instance, given the following block of numbers in Excel (each in
> different cells):
>
> 1 2 3
> 4 5 6
> 7 8 9
>
> If I copied the block and paste it into Mathematica then I would get...
>
> 1 2 34 5 67 8 9
>
> After which I would have to edit the entry with separators.
>
> {1, 2, 3,4, 5, 6,7, 8, 9}
>
> For this case it was easy, but for large blocks of number this gets
> somewhat confusing.
> How do I prevent Mathematica or Excel from forcing numbers to run
> together?
>
>
> Thanks,
> Lawrence
>
>