Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Hi...I have 4045 rows of data that look like this:
16TH FL BENN TOWER/4385 3900 CHESTNUT/6178 I need to separate out the 4 diget code after the /...so it's in a column by itself. Can you help me with the code. Thank you. DaveB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Dave,
I'm not sure you need code, try this Make sure you have a blank column next to your range then: Select your range containing the data from the menu choose Data - Text to Columns choose Delimited and hit next under the delimiters heading choose Other and type in a "/" (without quotes) hit finish Dan E "DaveB" wrote in message ... Hi...I have 4045 rows of data that look like this: 16TH FL BENN TOWER/4385 3900 CHESTNUT/6178 I need to separate out the 4 diget code after the /...so it's in a column by itself. Can you help me with the code. Thank you. DaveB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Dave,
Using cell A1 as an example. Two ways (there are others)..... If it's always the rightmost 4 characters....... =RIGHT(A1,4) If it's always the 4 characters after the slash.... =MID(A1,FIND("/",A1)+1,4) John DaveB wrote: Hi...I have 4045 rows of data that look like this: 16TH FL BENN TOWER/4385 3900 CHESTNUT/6178 I need to separate out the 4 diget code after the /...so it's in a column by itself. Can you help me with the code. Thank you. DaveB |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Dave
Select your column and choose Data, Text to Columns. Click OK for the first screen. Choose Other separator on the second and enter / in the check box. The slash is removed and the data is separated. Regards Peter -----Original Message----- Hi...I have 4045 rows of data that look like this: 16TH FL BENN TOWER/4385 3900 CHESTNUT/6178 I need to separate out the 4 diget code after the /...so it's in a column by itself. Can you help me with the code. Thank you. DaveB . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Or you can use the following formula:
=right(A1,4) in the next column and drag it thru 4000 rows hope it helps |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Or you can use the following formula:
=right(A1,4) in the next column and drag it thru 4000 rows hope it helps |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Or you can use the following formula:
=right(A1,4) in the next column and drag it thru 4000 rows hope it helps |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Or you can use the following formula:
=right(A1,4) in the next column and drag it thru 4000 rows hope it helps |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Or you can use the following formula:
=right(A1,4) in the next column and drag it thru 4000 rows hope it helps |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Or you can use the following formula:
=right(A1,4) in the next column and drag it thru 4000 rows hope it helps |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Data
Or you can use the following formula:
=right(A1,4) in the next column and drag it thru 4000 rows hope it helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating data | Excel Worksheet Functions | |||
Separating data in the same cell | Excel Worksheet Functions | |||
coma not separating data | Excel Discussion (Misc queries) | |||
Separating data in a cell | Excel Discussion (Misc queries) | |||
separating data | Excel Discussion (Misc queries) |