Hi SarahJ,

Any ideas on how to accomplish this and what might possibly be
separating the names.

Select the seperating char and hit Control+c
Then do a search and replace, control+v into the search box and space into the
replace box. Then replace all.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com