How do i ignore letters in a formula?

's Computer Specifications

I'm using the formula below, but, it only works on a single cell. I need to
make it work for certain column?

=LEFT(MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),MAX(SEARCH({0,1,2,3,4,5,6,7,8,9},"0123456789"&A1))),SUMPRODUCT(--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&(LEN(A1)))),1))))

's Computer Specifications

I don't think that formula ignores letters, as such. If you have a
single number in A1 it will exract that, e.g. it will take 342 from
"xyz342abc". Is that what you want to do?

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515128

's Computer Specifications

I want to be able to add a column with mixed numerals. For example: The sum
of A2:A34 with the values in the cells being 1B or 1F or so.

"daddylonglegs" wrote:

>
> I don't think that formula ignores letters, as such. If you have a
> single number in A1 it will exract that, e.g. it will take 342 from
> "xyz342abc". Is that what you want to do?
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=515128
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove/Ignore Letters when Summing cells in a column.	Matt	Microsoft Excel Worksheet Functions	3	18th Dec 2008 06:37 PM
Using SUM function to count hours BUT ignore Letters?	Will H, England	Microsoft Excel Worksheet Functions	6	8th Dec 2008 02:01 PM
Ignore formula	=?Utf-8?B?QXJuaWU=?=	Microsoft Excel Programming	1	19th Jul 2007 09:03 AM
Ignore letters, recognize numbers	=?Utf-8?B?R2VlLi4u?=	Microsoft Access Form Coding	3	1st Jun 2007 05:10 PM
Ignore #N/A in a formula	archanapatelwhite@googlemail.com	Microsoft Excel Misc	1	14th Feb 2007 03:16 PM