Need help breaking apart a formula

  • Thread starter Thread starter hg
  • Start date Start date
H

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.
 
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.
 
Back
Top