Need help breaking apart a formula
Thank you:)
"Jim Thomlinson" wrote:
Highlight column A and select Data | Text to Columns
--
HTH...
Jim Thomlinson
"hg" wrote:
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.
|