I have a table which represents ranges of postal codes.  Column A holds the
bottom of the range, while column B holds the top of the range.  For example
in A1, I have A0A, and in B1 I have A0O.  This represents the range of all
postal codes from A0A to A0O.  Column C and D hold ...

I need to be able to either set a variable value or use a formula that will
extract only the numbers that appear prior to the first "X" in a cell
starting from the right. For example:
3.5X16X6 Would return 6

We have a vendor who sends us spreadsheets listing photo specs. There can be
several hundred specs in a sheet. Each one of these is accompanied by a long
list of descriptors: Key terms we use to catalog the photos in our database.
All of a photo's descriptors appear in one cell, ...

I have data in Column D:BG
Mostly Cell have Strike Through Effect & Bold as font style.
How can we count those cells which are having strike Through Effect in
it.

(Hopefully my last question today.)
so i have a formula similiar to below. I need to have ( ) in the sentence as
well as other possible symbols, that I dont want as part of the formula. How
do I exclude?

I am setting up a spreadsheet which only need consecutive dates which are
Fridays.
Microsoft Excell 2003, SP2

We have about 20 new customers each week that we would like to send a
"Welcome" letter to.  I get their name and address from our core
system, but everything is in ALL CAPS and the Name column is in the
format LASTNAME, FIRSTNAME.  I have to break them apart using the

Inside a worksheet I'd like to know how to format a cell to become a button
where I can click it and it would act as a radial button as if it were inside
a test like some web pages contain.  This would greatly be helpful to me in
my project for my boss.  If anyone could help me ...

I have an excel spreadsheet with mutliple addresses. One of the columns
lists "county". I need to filter those address that are within any one of 14
counties. Is this a custom filter or other method to limit my pick to all of
those 14 counties out of the 100 or so counties in my ...

I'm trying to make a Macro that inserts a blank row each 1000 rows... I have
a DB with 18K rows.
Thanks in advance to anyone that can help me!!!
OSK

Is there a way to sort a pivot table based on a specific criteria?  
Specifically I want to show only customer totals that are less than a
specific figure I define, in this case 1500 lbs.

I need to total time spent on clients in a month some of that time is
billable and some is non billable I have formuls breaking that down in
colums,
I have the clients names in a list, what I need is to show the total for

I'm sure there's an easy solution to this, but I can't figure it out... can
anyone assist?
I'm currently working on a budget for our company.  We code things by
project (two letter code, example "CB") and each project has the same account

I want to know which employee is 19 years old or older based on a 365 day
year. Can't figure it out.  Please help.  Thanks.

Hi, I have a workbook with over 100 sheets in it and each sheet is protected,
at the moment I am unprotecting each sheet one at a time, is there an easyer
way to do this, unprotect or protect all the sheets at the same time, so I
can make changes to all in one go?.