[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Extracting part of the data from a single Excel cell

nigelbarham

12/15/2006 11:46:00 PM

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.
6 Answers

Don Guillett

12/15/2006 11:59:00 PM

0

If you want a formula solution.

=MID(C8,FIND("--",C8)+2,FIND("---",C8)-FIND("--",C8)-2)

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"nigelbarham" <nigelbarham@gmail.com> wrote in message
news:1166226351.230045.13910@l12g2000cwl.googlegroups.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.
>


nigelbarham

12/16/2006 12:16:00 AM

0

Wow. Your response was so fast, and it worked perfectly! Thanks!

nigelbarham

12/16/2006 12:29:00 AM

0

One more question. How would I extract the data after "----" (so, in
the case of the first cell, "33")?

Don Guillett

12/16/2006 12:56:00 AM

0

Just use the same idea presented to work it out.

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"nigelbarham" <nigelbarham@gmail.com> wrote in message
news:1166228918.959419.95440@79g2000cws.googlegroups.com...
> One more question. How would I extract the data after "----" (so, in
> the case of the first cell, "33")?
>


nigelbarham

12/16/2006 11:03:00 AM

0

Took a while, but I figured it out. Thanks again!

Don Guillett

12/16/2006 1:34:00 PM

0

Glad to help.
See how much better it is to figure it out yourself. Post you final
solution.
--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"nigelbarham" <nigelbarham@gmail.com> wrote in message
news:1166266963.510406.43220@n67g2000cwd.googlegroups.com...
> Took a while, but I figured it out. Thanks again!
>