Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting sub-strings from a large string
I have a large list of about 1,200 names and addresses in one cell
with each name+address being separated by a semi-colon. I want to pull out each name and address and place it in a separate row. I would really appreciate help with this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting sub-strings from a large string
Hi,
This assumes your data are in A1. Right click your sheet tab, view code and paste this in and run it. It will put the split data in A2 down Sub stance() SrcData = Range("A1").Value OutPutData = Split(SrcData, ";") For SplitData = 0 To UBound(OutPutData) Range("A" & SplitData + 1) = OutPutData(SplitData) Next End Sub Mike " wrote: I have a large list of about 1,200 names and addresses in one cell with each name+address being separated by a semi-colon. I want to pull out each name and address and place it in a separate row. I would really appreciate help with this. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting sub-strings from a large string
Have a look at datatext to columnsdelimited; -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... I have a large list of about 1,200 names and addresses in one cell with each name+address being separated by a semi-colon. I want to pull out each name and address and place it in a separate row. I would really appreciate help with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting strings from cell | Excel Programming | |||
Extracting numbers from alphanumeric strings | Excel Worksheet Functions | |||
extracting numbers from alphanumeric strings | Excel Programming | |||
Extracting time from strings | Excel Programming | |||
extracting numerics from literal strings | Excel Programming |