Function to extract string

Hello,

Need a function to extract the third part from the below strings: (sample worksheet attached)

DOC. NO. RESULT
LMH-B-05.1.1-A-01201-00 05.1.1
LMH-B-08-A-01301-00 08
LMH-B-04.2-A-01402-00 04.2
LMH-B-56.03-A-01403-00 56.03


Thank u.

Try
=RIGHT(RC[-1],LEN(RC[-2])-SEARCH("-",RC[-2]))

Not working.

Try:

=LEFT(TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",99),2),99,99)),FIND("-",TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",99),2),99,99)))-1)

Perfect.
Thank you.

Or try in B2 and copy down:

Formula:

Please Login or Register  to view this content.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Administrative Note re. Forum Guideline #2:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter and rarely necessary.

If you are responding out of sequence, it is usually enough just to mention the helper's user name (e.g @AliGW).

If you do need to quote, limit the quoted section just to the section to which you wish to draw your helper's attention or a direct question to which you wish to respond.

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

You are Welcome!

Thanks for the feedback and rep .

Glad to have helped.