I would like to use the autofilter function on an imported database.  
Unfortunately I don't have the ability to alter the database until after I
import it into Excel.  The problem I have is that some of the columns have
more than one record per excel row.  For example:

I see many threads discussing how to take contents of various cells and
concatenate into a single cell on separate lines (= A1 & char(10) & A2 &
char(10) & A3 ....., etc.).  How do I do the inverse process?  In other
words, how do I take a single cell consisting of multiple ...

In Excel 2000, on merged cells I am using conditional formatting to apply
formatting including fill color and borders.  On some cells the borders only
show on part of the merged cell.  It may appears like the border is only on
the first cell of the merged cells.  How do I fix?

Client inherited some files with pivot tables that are pulling data from an
Access database. The access database was moved to a different drive so when
she tries to refresh the database, she gets an error that the file can not be
found. We have tried to redirect it to the correct ...

I would like to have the (#N/A) caculations appear a (0) within the following
formula.
=VLOOKUP(A2,'RUNNING DATA wkly'!AO$3:AR$6000,4,0)

I have been given a list of hospitals in the UK. The format is:
The Royal Infirmary of Edinburgh [Edinburgh]
As you can see the city the hospital is located in is enclosed in square
brackets.  What I want to do is split it so that the hospital name is in

I have an Excel worksheet where I'm trying to display a value in a field
based on the state selected in another field.
For example if the state is TX, the value is 100, if the State is FL, the
value is 120 etc.

I've created a formula that includes text and also variables from other
cells. Is it possible to format different parts of the formula differently,
e.g. bold some of it? For example:
="Beginning of sentence "&TEXT($D$26,"$##,####.00")

I have the following scenario that I'm trying to wrap my head around.
(col A) I have a column with a unique Building identifying numbers.
(col B) I have a column with a building ranking # (ranks how important the
building is, this not necessarily unique, there will be several ...

I am trying to create an IF that looks for a date range from one column and
then counts items in another column.  The formula I have below is not looking
at the MONTH field.  Any suggestions?  Thanks!
=IF(MONTH(SHEET1!A2:A500*(2)),COUNTIF(SHEET1!G2:G500,"Successful"))

Thanks for anyone's help in advance . . .
A spreadsheet contains data in columns A-D, for 100 rows.  
In row 1, a title for each column exists.
How do I have each row's Column E contain the column title for the cell in

My pivot table is summarized by group, then by Actual Headcount and Budget
Headcount.  So for example, HR is the first category broken down into 10
heads of budget and 9 heads of actual.  The Total line sums the Budget and
Actual total to show 19.  I would like the Total line to ...

Hello I have the following macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$D$9" Then
Call Calculation

I have copied numerous worksheets from another workbook and I need to sort
all worksheets alphabetically. Other than manually, can EXCEL 2003 do this
for me?

Hello! I have a list of 1 to 10 ($A$1:$A$10). In the column beside the
numbers, I have names ($B$1:$b$10). In cell $C$1, I created a validation list
of my numbers. In cell $D$1, I'll like to change my names according to the
number I choose in my list.