One option:
=LEFT(A1,FIND("
",A1)-1)&MID(A1,MAX((MID(A1,ROW(INDIRECT("1:"&LEN(A1))), 1)="
")*(ROW(INDIRECT("1:"&LEN(A1))))),255)
Confirm the formula by holding down Ctrl and Shift, and then hit
Enter.

Hope it helped
Ola Sandström


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