How do I extract 3 numbers inside a longer number to another column ?

D

Dbase Beginner

Hi,


How do I extract the 008 from e.g. CV002-008-004_001 or the 001 fro
CV002-001_001 to another column ?


Thanks in advance
 
R

Ron Coderre

Try this:

With CV002-008-004_001 in A1:
B1: =LEFT(MID(A1,FIND("-",A1)+1,255),3)

That returns 008

Does that help?

Regards,
Ron
 
M

MBo

Use the following fromula
=MID(your cell,7,3)

This works only if you "008"s or "001"s are always 7 characters from the
left...

MBo
 
Top