If you save as tab-separated CSV file, it should do the trick since Excel expects CSV to be separated by tab by default. Alternatively you can save the comma separated values file with extention ".txt" and then ask excel to open the *.txt files. This will bring up a wizard where you can modify all the import settings.
Cheers Sakis On Mon, Jun 17, 2013 at 5:07 PM, Frank Ervin, MD <frank.er...@gmail.com>wrote: > > We need to be able to move data from spreadsheet to an existing Excel > (Office 2004) file . Copy and paste seems not to work; save as comma or > tab delimited file seems not an option. > Is there a mechanism I am overlooking? Please advise > > > Frank Ervin, MD > frank.er...@gmail.com > > > "The average person avoids the truth as diligently as he avoids arson, > regicide, and piracy on the high seas, and for the same reason, because he > believes that it is dangerous, that no good can come of it, and that it > doesn't pay." HL Mencken > >
