General

Why did Excel create two identical worksheets?
I am using Excel 2003 - Version 5.1.2600 Service Pack 2 Build 2600. When I open a particular file, Excel shows that two files are open. They are named the same but end with :1 and :2. Why did this occur and how can I delete one of these? ... 2 Jul 2008 10:52

Formula does not work after import of .txt file
I have imported a .txt file into my spreadsheet, however when I enter a formula it does not do anything. This is the formula I am entering =if(len(b1)=3,"0"&b1,b1) That is exactly how it shows up in the cell it does not calculate the formula. Is there a way to fix this without having to copy the data into a ... 2 Jul 2008 09:50

conditionally export Excel to Word
I want to export specific cells' contents from Excel to Word, if conditions are present. Specifically, if the text in cell A2 = "No" then ignore. If the text in cell A2 = anything other than "No", export the contents of A3 and A4 to a specified Word document. ... 2 Jul 2008 09:50

row matching using IF
I have two sets of rows that I want to match on account number. I have formatted them both to number if I subtract one from the other I get zero and if I add them I get the sum but if I use the following =IF(D2=L2,1,0) I still get zero. Can someone explain? ... 2 Jul 2008 09:50

Excel Pricing - help please
Hello, My question is almost exactly the same as Pauline - rockstars on, 6/27/2007, it concerns price breaks, i.e $100 for orders of 1 - 100, $90 for orders of 101 - 200 etc etc, however, I have 12 volume price breaks, and apparently can't use more than 7 'if' commands, can anyone think of a way? EG. 1-100 ... 2 Jul 2008 10:52

formula creating itself
I have a workbook with several different formulas. In one section the are cells that contain formulas which do certain things according to what day it is. Cells w20 through w26 have formulas w27 through w30 have no formulas. When a value is input into o20 through o30, w27 - w30 suddenly have a formula in them a... 2 Jul 2008 08:48

help on this graph please.
Hi, I have 3 colums 1 = date 2 = numbers 3 = names I want to put the date on the Catagory X axis The numbers in the Value Y axis and the names must be diffirent series. at the moment the names is all one series. please help ... 2 Jul 2008 08:48

Formula creating itself
... 2 Jul 2008 08:48

how can i insert a word into many cells in a list
I have a list of words, say 40 or so, and I want to insert one word into each cell, which is the same word, without typing that word into each cell. is there some way of doing this? The word will go before or after the word in the list, not in the middle of it. I searched for a prefix formula but seem to have ... 2 Jul 2008 10:52

Unable to copy and paste in excel
Hi I hope someone can help I am unable to copy and paste within excel if i right click on the cell, it works if I press ctrl c and ctrl v but if i right click the option to copy is greyed out. Also everytime I open up excel I need to go into tools - options - edit and select Allow cell drag and drop because... 2 Jul 2008 11:54