parse

Hello, I am pulling data from a table, but need to separate the words by the spaces and store them in separate data elements. For example, I am pulling the persons name JOHN SMITH. I need to input JOHN in one location, and SMITH in another. Therefore, I need to split and save the words...