The attached adapted as per your requirements. Be aware the name formatting is not the same in both sheets, on the first one there is a space between the comma and the rest. ( hence the use of the SUBSTITUTE function)
I left everything blank if no name was found
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|