Thank you for the feedback, basically what it does is looking at next 2 rows in column B whether it is empty; if it's empty (means merged cell) then add a space in between the names and concatenate them, else just return an empty string


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin