Posted to microsoft.public.excel.misc

external usenet poster

Posts: 2

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Breaking down an excel formula	[email protected]	Excel Worksheet Functions	5	October 11th 07 07:50 PM
breaking links	Pammy	Excel Discussion (Misc queries)	1	September 20th 07 05:58 PM
Hyperlinks keep breaking	EGNAPM	Excel Worksheet Functions	1	September 18th 07 10:10 PM
Breaking Links	Krandall	Excel Worksheet Functions	0	March 6th 07 02:40 PM
Breaking apart first and last names	LyndieBee	Excel Discussion (Misc queries)	2	December 2nd 04 09:00 PM

All times are GMT +1. The time now is 03:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us