Posted to microsoft.public.excel.misc

JE McGimpsey

Posts: n/a

Reverse concatenate

One way:

Choose Data/Text to Columns...

In article ,
Amy wrote:

I have cells that contains first name, last name, street address, city,
state, and zip. How do I seperate these into seperate columns.

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
Reverse Concatenate	Kate Was Here	Excel Worksheet Functions	6	February 9th 06 11:11 PM
reverse of concatenate	S.G.Pillai	Excel Discussion (Misc queries)	4	November 1st 05 12:27 PM
Concatenate	Jeff	Excel Discussion (Misc queries)	4	October 5th 05 04:39 PM
Using Concatenate inside a vlookup	bmclean	Excel Worksheet Functions	3	July 5th 05 09:29 PM
Concatenate cells without specifying/writing cell address individually	Hari	Excel Discussion (Misc queries)	4	January 3rd 05 06:05 PM

All times are GMT +1. The time now is 06:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us