View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yagna yagna is offline
external usenet poster
 
Posts: 12
Default 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.