Phil,

You're a prince! Thank you so much for your help! Stay safe.

:-)

"Phil" wrote:

HI Nancy

assuming the names are all in the same column, try using the Text to
Columns tool to split them. You may need to paste the results into the
respective columns afterwards, but it's a nifty way of doing it!

HTH

Phil