[dba-Tech] From body of email to a spreadsheet

Susan Harkins ssharkins at gmail.com
Sat Dec 26 12:02:13 CST 2009


The problem is that there's no consistent format -- responders just type as 
they like. I have to cut and paste into Word where I delete hard returns. 
Then, I paste into an Excel cell -- that works Okay but is a real pia when 
there's a lot of comments.

I really don't think there's an easier way other than to convince the powers 
that be that a web app is the way to go! ;) That would eliminate 99% of the 
work, but would cost money to develop.

Susan H.


> Hi Susan,
>
> If you copy the lists into a Word document, are they such that it would
> be easy to use Table>Convert>Ttext to table?  If so, then the new table
> would be easy to export into Excel.
>
> Hope you had a wonderful day, yesterday - I did.
>
> T
>
> Susan Harkins wrote:
>> A few times a month, I receive emails that contain longs lists -- and the
>> format is never the same. I must then copy those lists into an Excel
>> spreadsheet. It is time consuming. :(
>>
>> I'm going to play around with this today and see if I can't find some 
>> kind
>> of shortcut by copying it into Word first... but there's got to be a 
>> better
>> way than just pasting each item individually into an Excel cell.
>>
>> Any ideas would be appreciated.
>>
>> Susan H.
>>
>> _______________________________________________
>> dba-Tech mailing list
>> dba-Tech at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>> Website: http://www.databaseadvisors.com
>>
>>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com 




More information about the dba-Tech mailing list