Excel does not work

  • Thread starter Thread starter DrunkenSnowMonk
  • Start date Start date
D

DrunkenSnowMonk

Hi everyone,

1)I would like to know why after a certain number of rows excel doe
not seem to sort properly.

EX. I have a database of telephone numbers and address and dat
aquired. after about cell 800 when i try to sort it by date, the dat
is not in chronological order, sometimes it seems to be formatte
differently with whitespace that i never even put in there? what is u
with that


2) I have part of my database that is in lower case and the rest i
capitilized, how can i put the lowerecase to uppercase without havin
to type it all over again.


Thank you and thank god there is a "excelforum".


p.s. what is the difference between excel, access, sql and oracle.


Stupid questions, but i'm sure you wizards will yawn in your reply
Thank yo
 
If the sort is not sorting properly, then you probably have mixed
numbers and text. Try =ISTEXT(A1) and =ISNUMBER(A1)
more information in comments of
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
The whitespace you see may be Required Blank or
non-breaking space ( ) particularly if you copied
data from HTML. You can convert them to blanks and trim
the result with the TRIMALL macro in the above reference.

Conversions of a selection to a particular case such as uppercase.
Many things in Excel (as opposed to VBA) don't care about the
lettercase. FIND and EXACT are case sensitive. SEARCH
is not case sensitive. The sort is not case sensitive.
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

You may be using a web based "ExcelForum" to post your
questions but it is the actual newsgroups where your questions
are being posted, and your questions are being answered
by others in the newsgroups who original came looking for answers.
You can read more about the actual newsgroups at
http://www.mvps.org/dmcritchie/excel/xlnews.htm

Excel is a spreadsheet package. The others in you list are
for accessing a database.
 
p.s. what is the difference between excel, access, sql and oracle.

In round numbers, and very terse terms:

Microsoft Excel is a spreadsheet , ~$100
Microsoft Access is a desktop based database and user interface
development/access tool, ~$100
Microsoft SQL Server is a server based database engine. ~$5000+. It comes
in several 'flavors'.
Oracle is a server based database engine, available on multiple platforms,
including Windows, UNIX, LINUX. ~$15,000+, comes in standard and enterprise
editions.

SQL is an acronym for "Structured Query Language", an ANSI/ISO standard.
SQL Server, Oracle Server, and Access support its use, as do other
relational database engines.

Oracle is a company, and also produces other data related software,
including asset management, human resource management, data collection,
reporting, web-based tools, etc.
 
access is the best choice

access data projects against MSDE

these can scale to sql server; and it doesn't cost you more than $100
for the acces license
 
Now you really just took on Troll status - You went for a war of words, got
beaten hands down by the Grand Master and have now degenerated into a petty
mudslinging idiot. A real pity because you probably had a lot of smarts to
offer if you hadn't been so blinded by your obsessive tendencies.
 
Do NOT reply>click the find button>browse to all (msnews.microsoft.com)>from
aaron>move to deleted items
 
hey **** you don

just because I'm right and you're a WUSS FOR USING EXCEL

that doesn't mean im just going to go away
 
yeah and then we can all be a happy family and write spreadsheets all day
long

managers upon managers writing spreadsheets non-stop

copying and pasting the same business logic into 100 different places

GROW UP KIDS TIME TO GET A REAL PROGRAM
 
Back
Top