I have a series of cells in a column that looks like {2X, 1X, 3X...}etc.  I
need to split the number from the letter, and yet  have it flexible, so if I
change a 2X to a 1X, the split   updates automatically, which is not what
Text to Columns does.  I am using Excel 2003.  If ...

I am using the advanced filter function. Here is my criteria list:
Symbol
AMR
BA

For some reason I can no longer print an excel document with hidden cells on
one page.  It keeps adding in blank space for all the rows that I hid and
printing out tons of pages.  I'm not sure what happened.  Where do I go to
fix this?

Hi, hope you can help me.
I'm trying to import information from one worksheet into a calendar -
if the date value fits, then info from cells on the same line should be
imported to the calendar page.

I am doing a Vlookup, when it comes to one of my lookups where there is
no colum index for that lookup value it returns #N/A.  How can I get it
to return, when there is no information, a 0?

In A3 there's a date, in date format:  May-24-06.  In B3 I would like a
formula that would insert MAY, picking up the month from A3.  If the date in
A3 is Apr-18-06, then I would like B3 to yield APR, and so on.     Connie

I have a document with several worksheets, each one containing data from
a specific geographic area. I also have one worksheet that contains all
of the data from every other worksheet - a master worksheet
representing all of the areas. Currently whenever I update one of the

Hi guys...
Here is my problem: In our office we have a workbook that we all use with a
vlookup to enter data from a table.
The vlookup will work on some computers but not on others!!  What in the

I have a column of info separated by a space.  Can I select this column and
convert to two columns?

Hi, hope you can help me.
I'm trying to import information from one worksheet into a calendar - if the
date value fits, then info from cells on the same line should be imported to
the calendar page.

I am trying to calculate points for a sales program based on YOY %
change with the following criteria:
2 – 4.99% - 2 pts   
5 – 9.99% - 5 pts   

Hi is it possible to change the set row numbers? as I have titles and want
the numbers to start from the 5th line down. But then I have some numbers I
want to leave out e.g
1.

Cells K5 through K12 have 8 game scores. Best 6 scores are counted. I'm
trying to remove the two worst scores and do an average on the remaining
six, and keep coming up with error messages.
Last formula I tried that didn't work was

I am creating a weekly log of what I sell in my restaurant.  Each column is a
new week and each row is a menu item.  I fill in the amount sold across the
page.  I am trying to lock the first column so I can read the menu items as I
go along.  

I am trying to write a formula to calculate points based on % change
YOY. The following are the award levels:
2 – 4.99%    5 – 9.99%    10 +%
2 pts                  5 pts                10 pts