
Quang T. answered 08/04/19
GIS Professional with experience in Python and Engineering concepts
Use the [Text to Columns] tool found under the [Data] tab.
From there, it provides you an option on how you want to separate the information in your cell. Delimited separates them by specific parameters (e.g. space, commas, etc.) while fixed width separates them by the position of the text in the column.
I am assuming that when you paste it, the info is in one column rather than just one cell.