Extract Number Formula Needed

[Dastnai]

Hi Everyone,

I am looking for a formula to extract the amount for each of these cells. Any help would be greatly appreciated.

Sample:
[TABLE="width: 396"]
<colgroup><col></colgroup><tbody>[TR]
[TD]UNIVERSAL 1420449 WASHABAUGH $55 11/21/2018[/TD]
[/TR]
[TR]
[TD]UNIVERSAL 1420449 WASHABAUGH $76 11/21/2018[/TD]
[/TR]
[TR]
[TD]UNIVERSAL 1420450 WASHABAUGH $55 11/21/2018[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 396"]
<tbody>[TR]
[TD="width: 396"]UNIVERSAL 1420450 WASHABAUGH $76 11/21/2018[/TD]
[/TR]
</tbody>[/TABLE]


Desired outcome:
$55
$76
$55
$76


Regards,

Dastnai

 

[Trebor76]

Hi Dastnai,

Based on your posted examples, this will do the job (change just the cell reference to suit):

=VALUE(MID(A1,30,4))

Regards,

Robert

 

[Joe4]

If all your entries are not the same length, then this should do what you want:

=TRIM(LEFT(SUBSTITUTE(MID(A1,FIND("$",A1),10)," ",REPT(" ",100)),100))

 

[Dastnai]

Yes I should have specified that in my request. They were not the same length. This works to perfection. Thank you.

 

[Rick Rothstein]

Yes I should have specified that in my request. They were not the same length. This works to perfection. Thank you.

Here is another formula (slightly shorter, one less function call) that you can also consider (it assumes your dollar value is always the second "field" from the right as all of your examples show)...

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