Extracting string between 2 characters

[Ochoa11]

Account	Object code	Description
001 -111141-
001 -14559 -
001 -99-01-X -121-00-54080 -
001 -99-04-X -122-73-5L010 -
001 -02-02-X -152-00-56133 -

<tbody>
</tbody>

I am looking to extract the string between the 2 last hyphens. For example, i need to extract the object codes; 111141, 14559, 54080, 5L010, 56133.
How can I do this?

 

[Rick Rothstein]

Give this formula a try...

=TRIM(LEFT(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",100)),200),100))

 

[jtakw]

Hi,

This will also work:

Book1
	A	B
1	Account	Object code
2	001 -111141-	111141
3	001 -14559 -	14559
4	001 -99-01-X -121-00-54080 -	54080
5	001 -99-04-X -122-73-5L010 -	5L010
6	001 -02-02-X -152-00-56133 -	56133
Sheet671

Cell Formulas
Range	Formula
B2	=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",100)),200))

 

[Ochoa11]

Account	Object code	Description
001 -111141-
001 -14559 -
001 -99-01-X -121-00-54080 -
001 -99-04-X -122-73-5L010 -
001 -02-02-X -152-00-56133 -

<tbody>
</tbody>

I am looking to extract the string between the 2 last hyphens. For example, i need to extract the object codes; 111141, 14559, 54080, 5L010, 56133.
How can I do this?

Thank you! they both worked! AWESOME! You guys are brilliant!! Thanks again!

 

[jtakw]

You're welcome, welcome to the forum.