Identify second line
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.
|