I had the same problem & couldn't find a solution. Just in case you still want to know, I did the following:-

Copy the data into 2 columns.

In 1 column set a macro, using find & replace, to...