I have a spreadsheet with Comments field in one of the cells. Cell includes varying length comments, my goals is to read the last comment from this cell.

So, really I am looking for a way to match anything after the last period "." in this cell and display it in the formated report via Vlookup. I experimented with Left and right fuctions, however, no luck.

Can someone please help. So, for instance the string can be something like:

Hello. This is a test. Test number one.

I would like to grab the last comment.

Similary, string can be something like.

Hello. This is a test. Test number one comes after number two. You must read test number one.

Regards,
John