How to return cell value if no dot exist instead of return "#VALUE" in Google Sheet / Excel?

Question

This formula do the job, but I do not want it to return #VALUE!, instead of the name if no dot exist end of string.

Also

"Dr. Mrs Zainab Adams." -> "Dr Mrs Zainab Adams." I would like to return "Dr. Mrs Zainab Adams" in this case

=LEFT(G2, SEARCH(".",G2) - 1) & RIGHT(G2, LEN(G2) - SEARCH(".", G2))

Answer 1

=PROPER(IF(RIGHT(F2,1)=".",LEFT(F2,LEN(F2)-1),F2))