I would like to extract numeric values from a alphanumeric field. I can't
find an example of what I am trying to do.
Example;
1. Cell contains "bpnth500unwumm".  Looking for a result in a different cell

Example:
Name     Qty        Cost          Total
ABC        10         1.00          10.00
BC                                         0.00

I have an excel spreadsheet of approximately 1500 Names,addressses etc.
there are many duplicate cells of which I want to delete the duplicates and
I am looking for the best way to accomplish this.
I am new to excel and using formulas but if there is a way to use color to

OK, this is a bit of a tricky problem....
i have a 7*7 matrix in excel, which is full of numbers...
i want to search in only half the matrix, where half is from cell1-1,
to cell 7-1 (i.e. top left to bottom right).  what i want to search is

I have a fee that needs to be rounded up to the nearest even integer, since
the fee is billed in two halves and my boss wants 2 even billings. The
following rounds 1.5 up to 2:
=EVEN(1.5)  so that 1.67 is rounded to 2

I am trying to create a spreadsheet from an Adobe Acrobat file.  I'm getting
an error when Excel starts ups which states that the file is not completely
loaded. When the spreadsheet opens in Excel, the last column is IV.  Is there
a way to expand the spreadsheet to more columns ...

I m trying to copy the format from one cell to other(not the content of the
cell), i dont want to apply the same format for all the cells in the same
workbook.
Each time clicking on the format painter icon takes time, so i m searching

I want to display a range of quotes in one cell from a formula in that
cell...if you can make sense of that. The first part of the formula works
well and displays one of five messages but I cant add any more formulas to
the existing one without getting error messages, for example ...

How do I mark the end of  a spreadsheet? I want the cursor to jump down one
row and over to the first column instead of keep moving to the right and out
of my six cell spreadsheet. I am trying to simplify data entry by avoiding to
take the hand of the 10 key pad. Is this ...

Is there a way of permanently arranging in col. H that the result of  the
amount in col. D plus amount in col.E less the amount in col.F is
automatically shown once the entries in cols. D, E & F have been made. I am
tired of using copy and paste system!

how can I show the formula inside a cell, instead of its value?

I do AutoFilter to create a subset of data.  Then I want to create a PivotTable on the *subset* and do a count.  I then realize PivotTable doesn't work on the subset even though the rows are hidden.  It works on the entire database.  To circumvent this, I do copy/paste of the ...

I have a master data sheet that contains reciept numbers in column "A",
description in column "B" and amount in column "C".
I need a formulae that can sum amounts with the same similar description.
Thanks in advance

I am trying to create a table of the difference between two polynomial
trendlines on a graph. The data has about 1200 data points, but the Y
values are only between 0%-100%.
Basically the graphs shows that when line1 is zero, line 2 is about

I am new to excel but have a project that has to be done so here goes.
Column 1 needs a dropdown list of Reason Codes  (i.e. travel, lodging,
meals, etc)
Column 2 needs a dropdown list of Activity Codes (Management, Training, etc.)