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.
"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))