I have a Column of pricing from a csv. file that has TBA in some rows (price
to be announced).  I would like to change TBA to a 0.  
I have started with =IF(E1="TBA",   ???
I also have a coded price column for cost price and would like to get rid of

I have a workbook (MS Office Excel 2003 SP2) that contains two
worksheets.
In worksheet 1, I have data in column B that I want to appear in
worksheet 2 column A.  As this is a worksheet in which the users will

I'm getting the error mesage "Unable to read file" when attempting to read a
worksheet created in 2003.  I'm using the same version of Excel that I was
using in 2003.  The file has been backuped to a diskette and sitting there
ever since 2004.  I attampted to open in Word but ...

The following formula is being used in spreadsheet A (Forecast) to get data
from spreadsheet B (List of Open Work Orders with various types of cost).
=IF(ISERROR(VLOOKUP($C10,WIPSUM.xls!$B$2:$AJ$2000,21)),"0",VLOOKUP($C10,WIPSUM.xls!$B$2:$AJ$2000,21))
Few questions regarding the ...

It's driving me crazy!  It seems like I could use the auto fill
function and it would keep the correct cell references for the
lookup.  What am I doing wrong?

I am using VLOOKUP to return data associated with the source data, which is
in cells. Some of the source cells are actually empty, and return a #N/A. I
wish to print the returned data, with a blank where the #N/A s currently are.
Is this possible?

I have alot of records in a Excel file.  Some cells are blank and I wanted to
color those cells.  How would I go about doing this?

I have a macro that reads in data from a .txt file. The data contains
user IDs that consist of the first 4 letters of their name and 4
numbers. When names are read in that begin with MARCxxxx (ie
MARC1234), excel is formating them as a date, and I lose the original

I have a large text file that I'm wanting to convert to a table.  I was
hoping to simply paste it into Excel & then split the fields using Text to
Columns.  The problem I'm having is - when I paste the data in, instead of
putting it all into one column (thus allowing me to use ...

I am using a computer with Office 2000 and XP. A previous user set up
several worksheets and programs to open  (from our work network) when excel
opens. What do I have to do to keep all these things from opening when I
start Excel?

I thought I'd ask if any of you were creating and using thease types
of spreadsheets and would like to share them.
I'm hoplessly lost when trying to create one.
Thanks so much,

I have a user who is trying to make a very simple form on an excel
spreadsheet --mostly text boxes, a check box or two. She finds that she can't
tab from field to field, though -- the cursor goes from cell to cell.  I find
I can only  tab from field to field in design mode -- are ...

hi i am having some differculties by putting some numbers in a column going
down and i have another column nex to it and i want the numbers from the
first column so that everytime i add some numbers to that column it will add
them up in he column next to it so its like a ...

I want to count the number of rows with Module (Column G) =1 and
Result (Column J) = "Pass".
I tried this:
=COUNTIF('auto test all'!G2:G540,"=1")

If I were new to a subject, I would read a book about it and practice the
exercises, rather than ask simple questions like: "How do I add the value in
cell A1 to the value in cell A2 and put the result in cell A3?". Excel is
like algebra. After discovering the solution to the ...