I have one workbook with two spreadsheets:
Spreadsheet 1 name:  5-digit_Consolidted
Spreadsheet 2 name:  Area_Codes_US&CANADA
I am trying to match the criteria from Spreadsheet 1 cell C1 and cell D1 to

I need to compare values in columns B & C of the same row on one sheet and
find a value match in a 2 column range of another sheet and return the value
of  column E of the same row from one sheet to another
             SHEET 1                                               SHEET ...

I am using Excel 2003.
It appears that Excel's search and replace function is ignoring the
tilde (~) character. I am simply trying to delete every instance,
within any character string or a single ~. I have tried the Search and

I am trying to set up a column where people enter the date that they are
attending an event. In order to keep things neat and ensure that we can sort
the column, we need all the dates to be entered in the same format. How on
earth can we do this with Excel?

I would like to format a cell for am/pm without having to use a space in the
middle.
ex 12:00 AM
I would like to type in it as

I have a worksheet that received dynamic feeds.  I want to preserve the value
at a certain point in time, such as 4 PM, without having to do a Copy, Paste
Special as Values every day.  Is this possible?  Thanks.

I recall using this in the past but it has been awhile and I can not
get this to work.
I have a simple table like as below... dates and payperiods:
PPStart   PPEnd   PPNumber

I have the current dataset:
Month    Fund    Region    Name
Jan        A         E           SH
Jan        B         W          FW

I have in Sheet A the following date ranges and corresponding data
               B2                  C2
D2
E2

I want to protect the columns so the sheet can't be made wider, but not the
rows so they can be made higher.
Am I making sense? :)
Or is there a way to make the rows so they will automatically change to

How do I make formulas (such as summations) automatically detect when I can a
value in one or more of the cell that are included in the formula without
double clicking cell everytime I make a change?

What is the formula to get the tab name into a cell?

I'm using Excel 2003 and am trying to calculate commissions.  My spreadsheet
is as follows:
A                     B                     C                 D              
 E

I believe there is any easy solution to my problem but after a few hours of
trying I just haven’t hit on it yet…hope someone else can.
I have 2 worksheets titled “data” and “jobs”.
I need to lookup a value from the “jobs” worksheet on the “data” worksheet

I'm trying to use a logical function to search text in a cell, see
below
=IF(SEARCH("DENTAL",A3,0) = 0, IF(SEARCH("VISION",A3,0) =
0,"yes","no"),"no")