Rick,

Rick thanks for the formula, unfortunately when I copied the formula down in
Col C, after the first name in row two, every cell after that is left blank.

Steve