Best way to read the contents of a cell line by line

[madmiddle]

Hello,

I have been given a task to check the difference between 2 times in a transcript.
The worksheet that I have been given has each transcript inside a single cells (1 cell per transcript). what would be the best way to read each line inside the cell?

Do I copy the contents to a temp text file and read it that way or is there a way to read each line inside a cell ?

I managed to code most things with a little guidance but i'm stumped on this one.

any suggestions greatfully received

thank you

Andy

 

[madmiddle]

ok i've used the split function:

txt = ActiveCell.Value
    
FullName = Split(txt, vbLf)

but the cell contains blank lines in the text. How do i populate the array ignoring all the blank lines ?