So many potential caveats, but this will work for the example provided (assuming input in cell H1)
=RIGHT(H1,LEN(H1)-(FIND(CHAR(10),H1,FIND("To:",H1)+2)))
Note, however, you lose the carriage returns in the original note, if any.
So many potential caveats, but this will work for the example provided (assuming input in cell H1)
=RIGHT(H1,LEN(H1)-(FIND(CHAR(10),H1,FIND("To:",H1)+2)))
Note, however, you lose the carriage returns in the original note, if any.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks