How would I extract a number (or series of numbers) using a single cell
formula from an alphanumeric text string that also contains spaces? One key
component of the number(s) in question, is that they have a space on either
side. See the example of the text string below:

I have a spreadsheet that has 14 individual worksheets in the tabs at the
bottom, I would like to be able to print entire spreadsheet including all
pages and have them numbered sequentially  1 of 25, 2 of 25, 3 of 25 and so
on.  My tabs at the bottom are in the correct order I ...

Does anyone know how to write the same formula but with one small
change:
Here is the original formula:
=PRODUCT(1+OFFSET($G530,0,3*(1-COLUMNS($FT530:FT530)),1,3))+1

I have created a template to record my weightloss, however, I have created it
using lbs for the actual weight and I would like to convert this into stones
and pounds.  I have tried dividing by 14 but it's just not working, I've also
tried to find a formula but again I'm ...

I'm working for a public access television station (Access SF in San
Francisco). We are trying to create a dynamic schedule using excel (since
Outlook does not contain the functionality we need). The key feature we are
looking for is the ability to create reports/formulas that ...

My math skills are deficient.  
I've tried to work with 4 different formulas provided for other check-digit
makers, but my source number is 8 digits, and while it's a simpler formula, I
can't figure it out based on the other formulas:

Hello, from a database query I have production dates in format YYYYMMDD (e.g.
20070227) I would like to convert this to a weeknumber. How can I do this?
your help is very much appreciated

With earlier versions of Esxcel. I could have 2 or 3 spreadsheets open and
work independently in each one. Now when I scroll or move around in one
sheet, they all move. I have different workbooks open when I'm doing this.

I would like to enter a name and address per cell. So it would have 3 rows in
rach cell. Is that doable?
Jane Doe
123 a street

...and how should it be written?
=IF($P30="","Y",IF(AND($W30<>"",VLOOKUP($W30,SAGE3,1,FALSE)=
$W30),"Y",""))
If the value of cell W30 is also present in the table SAGE3 there is

is it possible to get a behaviour like this in Excel?
A1 contains a text value ='C:\[file.xls]List1'!D51 (not a formula!)
A2 contains a reference to A1 so that it actually displays D51 in
external file.xls

Is it possible to lock and/or hide formulas but still be able to copy
them to a new sheet?

Hi,
I have time and text in one cell and need to update each cell (there are
1000+) and need to change the time in each cell.  I have used the custome
type hh:mm and need to add one hour to each cell. Any ideas? eg:

I know this is easier than I'm making it out to be - It's got to be!
I need to count cells in a column only if they are blank or if they contain
a specified text (in this case, it happens to be "N/A").
What formula do I use?

Previously I learned the following
=INDEX(rng,MATCH(SMALL(COUNTIF(rng,"<"&rng),N),COUNTIF(rng,"<"&rng),0))  array formula  à ascending order
=INDEX(rng,MATCH(LARGE(COUNTIF(rng,"<"&rng),N),COUNTIF(rng,"<"&rng),0))  array formula à descending order
I use them to retrieve the Nth ...