![]() |
Convert info from database to spread sheet
Hi.
I have to track data from a huge and old report that when copied and pasted into excel copies in one column. Is there something I can create- a template, form, macro- something that when I paste the data it puts in a usable format to create charts etc. I appreciate any help! |
Convert info from database to spread sheet
Is there some delimiter between the fileds in the copied data (comma, tab
etc)? If so, you can use DataText to Columns. If not, is there a way to export the data from the old database with a suitable delimiter? -- Ian -- "Scared CO-OP :)" wrote in message ... Hi. I have to track data from a huge and old report that when copied and pasted into excel copies in one column. Is there something I can create- a template, form, macro- something that when I paste the data it puts in a usable format to create charts etc. I appreciate any help! |
All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com