Extracting string between 2 characters

[Ochoa11]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Account
[/TD]
[TD]Object code
[/TD]
[TD]Description
[/TD]
[/TR]
[TR]
[TD]001 -111141-
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -14559 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -99-01-X -121-00-54080 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -99-04-X -122-73-5L010 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -02-02-X -152-00-56133 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Account
[/TD]
[TD]Object code
[/TD]
[TD]Description
[/TD]
[/TR]
[TR]
[TD]001 -111141-
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -14559 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -99-01-X -121-00-54080 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -99-04-X -122-73-5L010 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001 -02-02-X -152-00-56133 -
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.