Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Im not a programmer so can someone help me with code for the problem listed below.
I have a column of addresses in Excel. Example of original column is: Column A Street address, suite no., city, state zip Street address, city, state zip I need to start at the right and extract the data up to the first comma and second comma (individually) into their own columns. Then I need it deleted from the original column. I start with one column and end up with three columns. Examples of new columns a Column A Column B Column C Street address, suite no. city state zip Street address city state zip Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell to have comma-delimited values based on text | Excel Worksheet Functions | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
How to produce comma-delimited and quoted text file from Excel? | Excel Discussion (Misc queries) | |||
Paste comma delimited text into a spread sheet | Excel Discussion (Misc queries) | |||
I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) |