• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Separate names with formatting from a column


Dear Sir's,

This is the request from previous post below


I need some correction (below) in formula if possible.
please see attached file when I am applying this formula getting like this and need like below.

1. Remove all (JT)
2. Row 6 - If it is an individual person the middle initial seems to be there still - is there a way to remove?
3. Remove all (ETAL)
4. Row 47 - if there is no middle initial it is just merging the names - is there a ways to not do this?
5. Sometimes there is NO . Period after the middle initials, is there a way for these to still be removed?