Hi,

Am Mon, 22 Oct 2012 15:59:07 +0200 schrieb Claus Busch:

in C2 try:
=--(MID(LEFT(A2,MAX(ISNUMBER(MID(A2,COLUMN(2:2),1)*1) *COLUMN(2:2))),MATCH(1,ISNUMBER(MID(A2&0,COLUMN(2: 2),1)*1)*1,0),LEN(A2)))

this is an array formula to enter with CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2