Need help breaking apart a formula

[hg]

In cell A this is the formula :
BUYER_LAST_NAME BUYER_FIRST_NAME
BUYER_FIRST_LAST_NAME
BUYER_STREET1
BUYER_STREET2
BUYER_CITY BUYER_ST
BUYER_ZIP BUYER_INDEX BUYER_PHONE BUYER_WPHONE
BUYER_EMAIL DATABASE_BUYER_KEY
SALES_CODE

I need it broken up into columns of name, email, address, phone number. Is
there a way to do this without having to input into a new spreadsheet
manually. Thank you, any help is much appreciated.

 

[Jim Thomlinson]

Highlight column A and select Data | Text to Columns

 

[willwonka]

Is this all in one Cell?

If so, try using Data..Text to columns and using a space as the
delimiter. Using the Wizard you can tell it which columns to include
and to delete, if needed.

 

[hg]

Thank you

Highlight column A and select Data | Text to Columns