udprocks
Member
Dear Sir's,
This is the request from previous post below
https://www.excelforum.com/excel-for...ml#post5472827
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?
This is the request from previous post below
https://www.excelforum.com/excel-for...ml#post5472827
Separate names with formatting from a column [SOLVED]
Hi Glenn, This is the request from previous post below https://www.excelforum.com/excel-formulas-and-functions/1341344-arrange-names-in-cell.html#post5472827 sorry for inconvenience please see attached file when I am applying this formula getting like this and need like below. 1...
www.excelforum.com
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?