Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have to enter a log that has a long text comment per entry. I would also
like to maintain the new line formatting of the comment. The text is usually about the length of an average email. Is this a job for excel? Or should I consider something else? I want to be able to sort and filter the entries. Cull unnecessary entries and print what is pertinent... Any suggestions? Cass |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If all you have is a hammer, everything looks like a nail.
I don't think excel was created for stuff like this. And sorting based on a column long comments will sort by how they start (alphabetical). And depending on how long the average email is, you may find that you can't see all the text in the cell. If you're gonna try to use excel for this, I'd do some experimentation with minor amounts of data before committing to it. cass wrote: I have to enter a log that has a long text comment per entry. I would also like to maintain the new line formatting of the comment. The text is usually about the length of an average email. Is this a job for excel? Or should I consider something else? I want to be able to sort and filter the entries. Cull unnecessary entries and print what is pertinent... Any suggestions? Cass -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ok... I suspect that this is not the very best tool :)
But I want to sort by date, topic, and recipient for now. And eventually dump the entries to a database. I dont know of any other short term tool. Anyone have experience in this? "Dave Peterson" wrote: If all you have is a hammer, everything looks like a nail. I don't think excel was created for stuff like this. And sorting based on a column long comments will sort by how they start (alphabetical). And depending on how long the average email is, you may find that you can't see all the text in the cell. If you're gonna try to use excel for this, I'd do some experimentation with minor amounts of data before committing to it. cass wrote: I have to enter a log that has a long text comment per entry. I would also like to maintain the new line formatting of the comment. The text is usually about the length of an average email. Is this a job for excel? Or should I consider something else? I want to be able to sort and filter the entries. Cull unnecessary entries and print what is pertinent... Any suggestions? Cass -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you're gonna end up in a database, why not just start in that database?
(From a non-database user.) cass wrote: Ok... I suspect that this is not the very best tool :) But I want to sort by date, topic, and recipient for now. And eventually dump the entries to a database. I dont know of any other short term tool. Anyone have experience in this? "Dave Peterson" wrote: If all you have is a hammer, everything looks like a nail. I don't think excel was created for stuff like this. And sorting based on a column long comments will sort by how they start (alphabetical). And depending on how long the average email is, you may find that you can't see all the text in the cell. If you're gonna try to use excel for this, I'd do some experimentation with minor amounts of data before committing to it. cass wrote: I have to enter a log that has a long text comment per entry. I would also like to maintain the new line formatting of the comment. The text is usually about the length of an average email. Is this a job for excel? Or should I consider something else? I want to be able to sort and filter the entries. Cull unnecessary entries and print what is pertinent... Any suggestions? Cass -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Opening Excel with text box form fields | Excel Discussion (Misc queries) | |||
My Vlookup solution is too clumsy (longish) | Excel Discussion (Misc queries) | |||
how to compare text fields in 2 different columns in excel | Excel Worksheet Functions |