I am trying to setup worksheets that stem off of one master worksheet to automatically update data on all worksheets when entered into the master worksheet....

I have text from a report that is spread over several cells. Each cell contains 1 word. I want to bring all of these words into 1 cell, in Sheet1 A2. They...

Excel 2003. A report comes in in RTF format. It has the data for each of the 12 months all in 1 row and 1 column, separated by a space between each one. So...

Excel 2003. A report has in col A, 4 Headers (or segment titles) for the report which is in 4 parts, in Sheet1. Also data is in Col A below the 4 Headers. ...

In Excel 2003, you can use justify to make the text wrap at any point outside the host cell. Now in Excel 2007, it seems just to default into a word wrap...

I have a drop down list in cell B40. In the validation I wrote =If(A40="","",FORTYB) where "FORTYB" is the name of a list. It worked perfectly, only filling...

I have a spreadsheet that includes a column for year, a column for amount deposited in a 401(k), a column for growth amount, etc. The last column is the...

I have a user that is opening a worksheet that is stored on a public drive and when she opens it,all the data is unreadable, but the graphs are fine. But when...

How can I pass multiple references as one argument in a function. For example using the IRR function...IRR(values,guess): If I have values in both a...

I have a table that I created in a GIS of tax parcel numbers that are in a specific zoning district. I have another table that was created in my tax...

I am trying to use conditional formatting on a range of cells when the cell to the left of it matches a certain criteria along with less than or equal to...

When I do a vlookup and the lookup value is a negative number and negative numbers are in the lookup table I get a #N/A instead of the negative number I am...

I'm importing into Excel a column of data that represents 4-digit phone extensions. The range is from 1111-9999, sorted from top to bottom. Not every number...

I have a database query that is refreshing every 5 minutes. What I need to do is to save that file as a csv so that I can import the file into our shipping...

Hello all, I have a question about adding words to a function. What I want to do is have a final result of lets say 600 oz. in a cell. I am starting with...

I am trying to use Excel's Data Validation feature to validate whether or not a user has entered a valid excel range address. Does anyone know the proper...

I made a spreadsheet with 3 columns of numbers and 1 of dates. It is roughly 600 lines long, but when I try to "find" a value it comes back as not...

I'm using Solver to determine which combination of numbers in a column result in the given total. For example, the data is in E1:E42 and I've set J1:J42 to...

I just upgraded to office 2007. I have files that were created in older versions of excel. Some of them contain macros and some don't. When I go to my...

How do I get rid of old values in pivot table drop down lists? The original data has been deleted for months, even years, yet, the pivot table drop down still...