Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of the data from a single Excel cell
I have a column of cells:
ABC-1--2.00---0786759021----33 JYP-1--0.76---0786759021----54 NUJ-1--112.30---0786759021----18 .... How can I extract the data between "--" and "---" (in the case of the first cell "2")? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of the data from a single Excel cell
If you want a formula solution.
=MID(C8,FIND("--",C8)+2,FIND("---",C8)-FIND("--",C8)-2) -- Don Guillett SalesAid Software "nigelbarham" wrote in message ups.com... I have a column of cells: ABC-1--2.00---0786759021----33 JYP-1--0.76---0786759021----54 NUJ-1--112.30---0786759021----18 ... How can I extract the data between "--" and "---" (in the case of the first cell "2")? Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of the data from a single Excel cell
Wow. Your response was so fast, and it worked perfectly! Thanks!
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of the data from a single Excel cell
One more question. How would I extract the data after "----" (so, in
the case of the first cell, "33")? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of the data from a single Excel cell
Just use the same idea presented to work it out.
-- Don Guillett SalesAid Software "nigelbarham" wrote in message ps.com... One more question. How would I extract the data after "----" (so, in the case of the first cell, "33")? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of the data from a single Excel cell
Took a while, but I figured it out. Thanks again!
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting part of the data from a single Excel cell
Glad to help.
See how much better it is to figure it out yourself. Post you final solution. -- Don Guillett SalesAid Software "nigelbarham" wrote in message ups.com... Took a while, but I figured it out. Thanks again! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting part of a cell | Excel Worksheet Functions | |||
Extracting part of data | Excel Discussion (Misc queries) | |||
Extracting part of a cell | Excel Worksheet Functions | |||
Extracting part of Text from one cell to another | Excel Worksheet Functions | |||
Extracting data from a single cell | Excel Programming |