Is there a way to add text after a formula or function in a cell. Maybe to reference something.

I recently upgraded from Office 2000 to Office 2002. In 2000, when copying from Access tables and pasting into Excel, the data type integrity was maintained,...

can i have two look up tables. one that has old prices and part numbers and one that has price revisions and additional parts? If so, how do i do this so...

I have a spreadsheet that contains about 61 pages of information. Each row is 1 cell that we've made larger to accomidate an address being centered in the...

I have an excel file with 50+ worksheets in it, and all have some form of sheet protection. Whenever I need to make an edit, I have to unlock each sheet one by...

this is such an obvious one but I can't find it -- how do you get the headers to show while you're viewing the page on the screen? Print preview works fine,...

When I double click on an .xls file Excel opens but the file does not open, the only way I can open a file is to click on file and the open and navigate to the...

Hi All I am using the following formula in each row of column B =MATCH(A1, $C$1:$C$685,0) Col A Col B Col...

I am looking for a way to define a range based on the background color of cells. I need to name a range and have it consist of all cells with a white...

someone sent me this problem to be solved in excel, can anyone help? if you have 5 partners (A&1, B&2, C&3, D&4 and E&5) in how many ways can the couples be...

Hi everyone, Here is a problem that I cant seem to solve. I am inputting data into Excel that comes from a text document. I can get the data into excel no...

I was curious a friend of mine let me use his office 2000 CD so I could make some documents for work, I found out that since I borrowed it that it could be...

Conditional formatting has been used on several ranges. now I cannot add/delete cond. formatting because it is greyed out in format menu. please advise...

When I try to open any file, I get the message "File already open" and I am then unable to save any changes. Help!

due to the formatting of a report that I import as a text document into excel I get a problem with page breaks and other information that is not needed. Here...

Hi I have a file with a *.lis extension which I would like to import into excel for analysis. However when I do this it is not formatted correctly and requires...

hi, I have only worked on vba macros where my input and output is both excel. Using macros most of the time it crashes and the end-user is then not...

I have a spreadsheet that holds quality data for multiple products, indexed on the date and time of production. Data from this is charted so I can see...

Hi there, I have some quite complicated formulae that refer to a range in another worksheet. The range always starts at $A$8. The range extends down column A...

Could anyone help me with this please? If I have two lists of names in columns, can I get Excel to report or highlight those items that are present in one...