Well it can be done, but it's not a very nice formula...

=MID(A1,LOOKUP(MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0),SMALL((M ID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="
")*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&L EN(A1)))))+1,FIND("
",A1,MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0))-LOOKUP(MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0),SMALL((M ID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="
")*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&L EN(A1)))))-1)

The formula Must be confirmed by holding down Ctrl and Shift and then
hit Enter.

Hope it can be of use
Ola Sandström


Attached zip-file:
http://www.excelforum.com/attachment...tid=3646&stc=1


+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3646 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390520