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?
|