How do I convert an Excel file to an ASCII file?

I have a spreadsheet that has 3000 entries and I have a coloum called
SBS_No only problem is that I think I have duplicate entries as the
SBS_No is unique. Is there anyway that I could get excel to point out
any duplicate values. Like returning value false if it is a duplicate

I have a column of 350 e-mail addresses.  I need to convert them all to
e-mail hyperlinks so that when I click on one of the addresses, an e-mail
item is generated.
I have selected them all and played around with the hyperlink button, but

I would like to have a drop down pick list that returns the value from
an adjacent cell instead of the one picked.  For example, I have a list
of Units of Measures in one column and their abbreviations in an
adjacent column (i.e. "hundred weight" in cell b2 and "CWT" in cell a2)

I have column headings for several columns of data that I'd like to treat as
an Excel Table, not a pivot table, just a standard Excel table. What steps
does one take to define a block of data as a table? Is it done by simply
naming it?  My thanks for any assistance here.  Brad

I have a dollar amount in cell F23, say, with a formula in G23 to deduct
that from subtotal in G22.  The formula in G23 looks like this:
=IF($F23<>"",($G22-$F23),"")
This works great.

What I am trying to do is open two spreadsheets in excel but I would
like them to open in two different excel applications not in the same
application. In other words two different excel windows. Is this
possible ?

I find conditional formatting very useful however I would like to be able to
highlight an entire row/range of cells if one cell has a given value, using
conditional formatting I am only able to highlight the single cell. Is it
possible to have a range/row of cells formatted in ...

I have two worksheets. Both have a huge list of employees' names, in a first
name cell, then a surname cell. Some of the people appear on both worksheets.
I need to produce another sheet that shows every employee that exists on both
the original worksheets, plus pulling ...

How can i compare a range of cells an have them "reorganized" so that
the one that correspond is listed on the same Row?
AAA-AAA
BBB-CCC

For the Solver, is there any way to determine how many times the target cell
has been evaluated, either the total number until the solution has converged
or the number for each iteration? (Note that this would not be the same as
the number of iterations, since there would likely be ...

I need a excel/office 2003 formula to work out =countif(G$3:G$nn,G3) where
'nn' is calculated by another formula in another cell: =M1+COUNTIF(B:B,B3).
Seems like it should be easy but nothing I've tried works.  
None of the key words I've tried in Help have helped.

I have numerous spreadsheets that only initially has data in 2 columns
(Column A and B) and each spreadsheet has numerous rows.
I currently have to do the following:-
1.    Select from rows 51 to row 100 and cut and paste into columns C and D.

There is a speech facility in Excel which is great for my work but I would
like to have it where Excel uses the speech facility on opening a
workbook....sort of a welcome and basic instruction as soon as the file is
opened.

How do I add a formula to find 15% of an amount?  The amounts are listed in
column D.  I want to see 15% in Column E