Extracting part of the data from a single Excel cell

N

nigelbarham

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.
 
D

Don Guillett

If you want a formula solution.

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

nigelbarham

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

Don Guillett

Glad to help.
See how much better it is to figure it out yourself. Post you final
solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Cumulative formula for word table 0
List all tables, including document structure 0
Possible to Combine reports to's to a single box? 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Merging from an Excel file with graphics 1

Top