Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse concatenate
I have cells that contains first name, last name, street address, city,
state, and zip. How do I seperate these into seperate columns. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse concatenate
Look at Data==Text to Columns or use VBA with SPLIT function. How are the
fields delimited? "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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse concatenate
On Wed, 5 Apr 2006 06:36:02 -0700, 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. If the fields are separated by commas, you can use the Data/Text-to-Columns wizard specifying comma as the delimiter. --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reverse Concatenate | Excel Worksheet Functions | |||
reverse of concatenate | Excel Discussion (Misc queries) | |||
Concatenate | Excel Discussion (Misc queries) | |||
Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) |