Returning the last row of text in a cell, minus the first few words

Hi,

I found Rob Xaos reply to NickW which got me within inches of my goal (removing-all-but-last-line-of-text-from-a-cell).

I have a csv that a program spits out and the column that has the data I need has MANY lines of text in it. The bottom line is golden except for the first 5 words (27 characters including spaces).

So right now I am using =RIGHT(a2,LEN(a2)-FIND(CHAR(1),SUBSTITUTE(a2,CHAR(10),CHAR(1),LEN(a2)-LEN(SUBSTITUTE(a2,CHAR(10),""))-0))) to get this:

The remote host is running Microsoft Windows Server..... I need to remove "The remote host is running ". It is the same 5 words every time.

Thanks in advance for any help!!!

Chad

Thank you!!!!