Posted to microsoft.public.excel.worksheet.functions

ineedhelp

Posts: n/a

How do i ignore letters in a formula?

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},"01 23456789"&A1))),SUMPRODUCT(--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&(LEN(A1)))),1))))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ignore a cell used in a formula if it contains a negative value	Donald Thomas	Excel Discussion (Misc queries)	2	February 19th 06 02:18 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Can I use AutoFill or a formula to fill a series of letters?	tadpgk835	Excel Discussion (Misc queries)	3	April 28th 05 02:46 PM

All times are GMT +1. The time now is 07:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us