Thread
:
Extracting part of the data from a single Excel cell
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett