When I copy data from a pdf containing 4 columns of ticker symbols and company names into excel, it pastes all the columns into one cell. For example:

AAPL Apple, Inc. NKE Nike, Inc.

This should be 4 columns, with one for each ticker symbol and one for each company name. I'm wondering if there's a way to extract only the ticker symbols. Unfortunately the company names aren't consistent in the sense that they all end in "Inc." or anything like that. So I can't run an extract based on searching for those words.

I can extract the first ticker symbol fairly easily with the array formula below:

Formula: copy to clipboard 
{=MID(A3,1,MATCH(1,(CODE(MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1))<65)*1,0)-1)}


But I can't adjust it to populate NKE. Any suggestions?