Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract comma broken address to cells
I have address's that have been imported from a delimited text file in the
following format. 9,Hall,Street,Billytown,6666 I would like to extract it into colums ie Column 1 9 Column 2 Hall Street Column 3 Billytown 6666 |
#2
|
|||
|
|||
Take a look at DataText To columns, and use a comma delimiter
-- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... I have address's that have been imported from a delimited text file in the following format. 9,Hall,Street,Billytown,6666 I would like to extract it into colums ie Column 1 9 Column 2 Hall Street Column 3 Billytown 6666 |
#3
|
|||
|
|||
This puts all into seperate columns need as explained
"Bob Phillips" wrote: Take a look at DataText To columns, and use a comma delimiter -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... I have address's that have been imported from a delimited text file in the following format. 9,Hall,Street,Billytown,6666 I would like to extract it into colums ie Column 1 Number Column 2 Hall Street Column 3 Billytown 6666 |
#4
|
|||
|
|||
Sorry, I missed that nuance.
Think you have a problem, as a formula will need some definite data structure,. What happens to say 9,St,James,Street,Billytown how do we know the street has 1, 2, 3 or however many components? -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... This puts all into seperate columns need as explained "Bob Phillips" wrote: Take a look at DataText To columns, and use a comma delimiter -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... I have address's that have been imported from a delimited text file in the following format. 9,Hall,Street,Billytown,6666 I would like to extract it into colums ie Column 1 Number Column 2 Hall Street Column 3 Billytown 6666 |
#5
|
|||
|
|||
All address have the same make up. As shown.
"Bob Phillips" wrote: Sorry, I missed that nuance. Think you have a problem, as a formula will need some definite data structure,. What happens to say 9,St,James,Street,Billytown how do we know the street has 1, 2, 3 or however many components? -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... This puts all into seperate columns need as explained "Bob Phillips" wrote: Take a look at DataText To columns, and use a comma delimiter -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... I have address's that have been imported from a delimited text file in the following format. 9,Hall,Street,Billytown,6666 I would like to extract it into colums ie Column 1 Number Column 2 Hall Street Column 3 Billytown 6666 |
#6
|
|||
|
|||
OK, add this to B1 and copy down
=LEFT(A1,FIND(",",A1,FIND(",",A1)+1)-1)&" "&MID(A1,FIND(",",A1,FIND(",",A1)+1)+1,99) then do Text to Columns on B -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... All address have the same make up. As shown. "Bob Phillips" wrote: Sorry, I missed that nuance. Think you have a problem, as a formula will need some definite data structure,. What happens to say 9,St,James,Street,Billytown how do we know the street has 1, 2, 3 or however many components? -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... This puts all into seperate columns need as explained "Bob Phillips" wrote: Take a look at DataText To columns, and use a comma delimiter -- HTH RP (remove nothere from the email address if mailing direct) "bbc1" wrote in message ... I have address's that have been imported from a delimited text file in the following format. 9,Hall,Street,Billytown,6666 I would like to extract it into colums ie Column 1 Number Column 2 Hall Street Column 3 Billytown 6666 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i merge data in a row of cells to be comma separated in on. | Excel Discussion (Misc queries) | |||
extract data from cells | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
How do I extract cells from multiple workbooks | Excel Discussion (Misc queries) |