Re: Exporting report data

[ Q3 01 - Q1 03 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Exporting report data posted by Jim Schurz on July 06, 2002 at 12:59:49:

: I am looking for a way to export data from a report to Excel.
: All I have been able to do is copy and past the report data to Excel.
: This imports the data to Excel all in the first "A" column. Is there
: some way to import the report columns into Excel in seperate columns?

: Jim

Hi Jim,

Use "Edit/Copy" from the FM report, and then paste it into a text file,
rather than directly into Excel. Then, you can open this text file
from Excel, and choose the "Fixed Width" option to bring in the data
into their own columns.

Thanks,
Mark
--
Mark Beiley

Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
/XP

Replies: