0

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

enter image description here

enter image description here

enter image description here

1
  • 2
    Wrap in =IFERROR(LEFT(G2, SEARCH(".",G2) - 1) & RIGHT(G2, LEN(G2) - SEARCH(".", G2)),G2) Feb 8 at 18:07

1 Answer 1

0
=PROPER(IF(RIGHT(F2,1)=".",LEFT(F2,LEN(F2)-1),F2))
1
  • Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center. Feb 8 at 18:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.