Multiple Cell Values by Removing Blanks

[eforti]

Hello All,
I've copied some data from a table in a PDF and pasted it into excel. Each cell now contains about 4 cells worth of data, separated by spaces. So the rows were recognized correctly but the columns were not. Is there any way to create a formula that will enter the data between the spaces into the adjacent cells?

Example:

ABCD EFGHI JKLM-NO PQRSTUVWXYZ

Should be in 4 different cells in the same row as:
ABCD, EFGHI, JKLM-NO, and PQRSTUVWXYZ

Thanks in advance for any help

 

[Sektor]

Data tab -> Text to Columns button. Select "Space" as delimiter.

 

[eforti]

Love the simplicity! Thank you

In the past I've tried pasting special and these options came up, but they don't any more. Is that just a result of the version of excel?