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

Hi,


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


Thanks in advance !

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

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


"Dbase Beginner" wrote:

>
> Hi,
>
>
> How do I extract the 008 from e.g. CV002-008-004_001 or the 001 from
> CV002-001_001 to another column ?
>
>
> Thanks in advance !
>
>
> --
> Dbase Beginner
> ------------------------------------------------------------------------
> Dbase Beginner's Profile: http://www.excelforum.com/member.php...o&userid=20778
> View this thread: http://www.excelforum.com/showthread...hreadid=503412
>
>