This worksheet function should do it

=MID(D1,FIND(CHAR(10),D1)+1,99)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"yagna" wrote in message
...
I have a strange issue, in a cell I have two lines which is entered by the
user using alt+enter. Now I need to segregate only the second from each
cell
& manipulate teh data furhter. This data is full of text.
for eg: NCO
Yagna

Text to columns delimit or fixed width is not sovling the issue, the data
I
require. Any help on this.

thanks,
Yagna.