Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text in Excel
Is there ever a good reason for putting mostly all text into Excel rather
than a Word table? At my level of knowledge, I certainly can't imagine what advantage there would be. However, upon request, I recently placed over 20 pages into Excel, only one column of which contained ID numbers while the other 7 columns contained paragraphs of text, which was--for me, at least--a formatting nightmare. Do you have any words of wisdom that I can relate to my superiors that might in some way help them to see that Word would have been a much better choice? Or am I wrong? Could there possibly be a reason? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text in Excel
Hi,
Many reasons: 1. Excel's sort options are better 2. Excel has Filter options 3. You can use many functions against text in Excel such as COUNTIF(A1:A100,"Alaska") would count the number of occurances of the text Alaska in the range. 4. You can create frequency charts and Excel's charting tool is superior to Word's in 2003 or earlier. 5. You can use the SUBTOTAL command, Word doesn't have one. 6. There are a myrid of function is Excel which are not in Word and these functions may handle text or not in many cases. =TRIM(A1), FIND, LEFT, RIGHT, .... -- If this helps, please click the Yes button Cheers, Shane Devenshire "Island Girl" wrote: Is there ever a good reason for putting mostly all text into Excel rather than a Word table? At my level of knowledge, I certainly can't imagine what advantage there would be. However, upon request, I recently placed over 20 pages into Excel, only one column of which contained ID numbers while the other 7 columns contained paragraphs of text, which was--for me, at least--a formatting nightmare. Do you have any words of wisdom that I can relate to my superiors that might in some way help them to see that Word would have been a much better choice? Or am I wrong? Could there possibly be a reason? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text in Excel
If you won't need to manipulate this data or perform any calculations on the
numbers then by all means use Word. -- Biff Microsoft Excel MVP "Island Girl" wrote in message ... Is there ever a good reason for putting mostly all text into Excel rather than a Word table? At my level of knowledge, I certainly can't imagine what advantage there would be. However, upon request, I recently placed over 20 pages into Excel, only one column of which contained ID numbers while the other 7 columns contained paragraphs of text, which was--for me, at least--a formatting nightmare. Do you have any words of wisdom that I can relate to my superiors that might in some way help them to see that Word would have been a much better choice? Or am I wrong? Could there possibly be a reason? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text in Excel
Thanks, Shane, for helping me see reasons why Excel might have been the right
choice. "Shane Devenshire" wrote: Hi, Many reasons: 1. Excel's sort options are better 2. Excel has Filter options 3. You can use many functions against text in Excel such as COUNTIF(A1:A100,"Alaska") would count the number of occurances of the text Alaska in the range. 4. You can create frequency charts and Excel's charting tool is superior to Word's in 2003 or earlier. 5. You can use the SUBTOTAL command, Word doesn't have one. 6. There are a myrid of function is Excel which are not in Word and these functions may handle text or not in many cases. =TRIM(A1), FIND, LEFT, RIGHT, .... -- If this helps, please click the Yes button Cheers, Shane Devenshire "Island Girl" wrote: Is there ever a good reason for putting mostly all text into Excel rather than a Word table? At my level of knowledge, I certainly can't imagine what advantage there would be. However, upon request, I recently placed over 20 pages into Excel, only one column of which contained ID numbers while the other 7 columns contained paragraphs of text, which was--for me, at least--a formatting nightmare. Do you have any words of wisdom that I can relate to my superiors that might in some way help them to see that Word would have been a much better choice? Or am I wrong? Could there possibly be a reason? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text in Excel
Thanks, T, for your helpful advice. Some manipulation became necessary and
everything turned out okay. "T. Valko" wrote: If you won't need to manipulate this data or perform any calculations on the numbers then by all means use Word. -- Biff Microsoft Excel MVP "Island Girl" wrote in message ... Is there ever a good reason for putting mostly all text into Excel rather than a Word table? At my level of knowledge, I certainly can't imagine what advantage there would be. However, upon request, I recently placed over 20 pages into Excel, only one column of which contained ID numbers while the other 7 columns contained paragraphs of text, which was--for me, at least--a formatting nightmare. Do you have any words of wisdom that I can relate to my superiors that might in some way help them to see that Word would have been a much better choice? Or am I wrong? Could there possibly be a reason? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text in Excel
You're welcome!
-- Biff Microsoft Excel MVP "Island Girl" wrote in message ... Thanks, T, for your helpful advice. Some manipulation became necessary and everything turned out okay. "T. Valko" wrote: If you won't need to manipulate this data or perform any calculations on the numbers then by all means use Word. -- Biff Microsoft Excel MVP "Island Girl" wrote in message ... Is there ever a good reason for putting mostly all text into Excel rather than a Word table? At my level of knowledge, I certainly can't imagine what advantage there would be. However, upon request, I recently placed over 20 pages into Excel, only one column of which contained ID numbers while the other 7 columns contained paragraphs of text, which was--for me, at least--a formatting nightmare. Do you have any words of wisdom that I can relate to my superiors that might in some way help them to see that Word would have been a much better choice? Or am I wrong? Could there possibly be a reason? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text in Excel
I'll also add this to what Shane and TValko have said: IMHO you're far
better off in the long run to be in error and enter text into Excel and find you don't need to manipulate it than to enter it into Word and find out that you do. Case in point: We are often (as in routinely) given pages and pages of Word text laid out neatly in columns of information with a final column or two requiring numeric entry, where one column is a unit of measure and the final column is currency (cost). We end up replicating the pages and pages of Word in Excel so that we can use Excel's math abilities to ensure that our cost estimates are accurate and return the pricing schedule to the client in the layout they've insisted that it be in when returned. Of course, it could be worse, they could provide it all as an uneditable, uncopyable .PDF file ... and yeah, some of them have figured that one out and that's what we get from them. Arrrrggggggghhhhhhh! "Island Girl" wrote: Is there ever a good reason for putting mostly all text into Excel rather than a Word table? At my level of knowledge, I certainly can't imagine what advantage there would be. However, upon request, I recently placed over 20 pages into Excel, only one column of which contained ID numbers while the other 7 columns contained paragraphs of text, which was--for me, at least--a formatting nightmare. Do you have any words of wisdom that I can relate to my superiors that might in some way help them to see that Word would have been a much better choice? Or am I wrong? Could there possibly be a reason? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
HOW TO CHANGE BAHTTEXT (THAI TEXT) TO ENGLISH TEXT IN EXCEL | Excel Worksheet Functions |