Identify second line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yagna - 28 Mar 2008 11:30 GMT

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.

Reply to this Message

Bob Phillips - 28 Mar 2008 11:36 GMT

This worksheet function should do it

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

Signature

HTH

Bob

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

>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
[quoted text clipped - 9 lines]
> thanks,
> Yagna.

Reply to this Message

NateBuckley - 28 Mar 2008 12:19 GMT

You could try the following code, Works for me when trying it.
You'll have to change the sheet name and which cells to look at (obviously).
Hope this helps.

Dim splitArray() As String
splitArray = Split(Sheets("SheetName").Cells(1, 1).Value, vbLf)
MsgBox splitArray(1) 'Displays the second word from the sheet.

> 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
[quoted text clipped - 7 lines]
> thanks,
> Yagna.

Reply to this Message