Is there a formula that would add numbers together within a group of cells
and ignore the text e.g. (col a row 1) LDS12 (col b row 6) L9 (col c row 5) S7
returning the sum of 28?

I just bought Office 2007, and I have two questions regarding Quick Access
Toolbars.
1. I use Excel frequently, and I am taking advantage of the quick access
toolbars (below the ribbon).  Unfortunately, when you insert commads to QAT,

I want to create a macro, which let me automate the process of importing the
data from various files (*.xls) from a particular directory to the main table
in MS Access.
My Main table in access is called Wire Transfer Main table.  And every

How do I get my DateDif output to reflect the correct 30 days in a
month.  Im getting 49 days, it should be pulled to the months and 19
days in days.
2 years, 11  months, 49  days

I am getting ##### but closer together in my worksheet when trying to enter a
sales figure, i have chkd the format cells option with no joy, the rest of
the worksheet is behaving except this column, Doh!! any suggestions??? Please

Hello, i've got a little problem with time.
A2 = 22:00 ( start time )
b2 = 7:00 ( finish time )
c2 = 1:30  ( breaks )

Really strange problem with Excel 2007 and the Query Wizard. I've done this
hundreds of times with Excel 2000 and 2003. The set-up is Windows XP, Office
2007 connecting via ODBC to a SQL 2000 server via a ODBC system DSN
connection.

I'm having a strange problem with my Excel spreadsheet.  Up until a couple of
weeks ago, all the formulas in my spreadsheet worked fine, could be cut and
pasted, and automatically refigured when I would input new data.  Within the
past couple of weeks, the spreadsheet has stopped ...

Excel 2003
I have a block of data 13 columns wide, by about 1500 rows.  I'm feeding
that as a source to my pivot table.  The PT seems only able to digest the
first 810 rows.  I tell this by clicking on Pivot Table Wizard, back, and

I have a form with a multipage with pages names page1, page2, etc...
and I have a button on the form that makes the next page visible if
information is entered onto the first page.  Is there code to make
page2 as the focus when the button is pushed.

When using the find function, is there a way (separators...etc) to
search for more than just one keyword or Value?  I am looking for a
way to search for multiple items with a single query box.  I've tried
to use Boolean operators, semicolons, commas...etc.

I am making appointment letter for employees using mail merge option. In
appointment letter I have to put salary in number form i.e. 121000 and also
in figures i.e. One lakh twenty one thousand. I have a coloumn in excel where
I have all the salary package in number form. Is it ...

Im trying to send a worksheet via e-mail, but my mail as attachment icon
is grayed out.  Is there anyway i can fix this.

Getting this SUMPRODUCT forumula to work has me stumped.
For range: $E$3:$E$352 is not blank
For range: $S$3:$S$352 is equal to or greater than $P$3:$P$352 *2 (cells
where P is => 2x S)

I have the new office 2007 and our company requires us to route emails but
that option doesn't seem available? am i just not seeing it?