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 !


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

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

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=503412

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

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