Need help breaking apart a formula
 

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.

Need help breaking apart a formula
 

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.

Need help breaking apart a formula
 

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.



On Dec 13, 1:38 pm, 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.

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.