I think this returns what you want:
=LEFT(A1,MAX((--ISNUMBER(--MID(A1,ROW(1:10),1))*ROW(1:10))))
Note: commit that array formula by pressing [Ctrl]+[Shift]+[Enter]
If there will be more that 10 characters, change the 10's to an appropriate
number.
Does that help?
--
Regards,
Ron
"jeremy via OfficeKB.com" wrote:
This funtion works for me, if there are no letters behind numbers
=IF(ISNUMBER(B7),(IF(B74000, VLOOKUP(B7,Sheet1!A2:B263,2), "S")), "S")
but some of the numbers have a letter or two behind them, which I want to
ignore (eg. 4123HG i want to recognize as 4123)....
Any Help?
jeremy
--
Message posted via http://www.officekb.com