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

  • Thread starter Thread starter Dbase Beginner
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

How do I add 4 to xxx-xxxx_001 to get xxx-xxxx_004 ? 1
Automaticalle generate sequential reference number 2
Extracting numbers from alphanumeric string 1
how do I generate a unique reference number??? 3
adding zeros to numbers in columns 1
Formatting Numbers to 3 digit, 3
Changin cell format and view 3
how can I use preceeding zeros and data validation in Excel? 3

Back
Top