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!!!