Highlight Dollar Amounts

[Justinian]

I have a list of work order comments in range H2:H1150. In each cell is a comment like this:

"1/8/10 Employee at work-----refer to doctor----$750 cap per listing."

I am trying to extract just the dollar amounts from these cells so I can total them in column I but am having a hard time. I tried conditional formatting to highlight the cells that contain dollar amounts but cannot get that to work either.

Any ideas?

 

[Eric W]

If there is always a $ sign, then maybe:

Book1
	A	B
1	1/8/10 Employee at work-----refer to doctor----$750 cap per listing.	750
Sheet14

Cell Formulas
Range	Formula
B1	=LEFT(SUBSTITUTE(MID(A1,FIND("$",A1)+1,LEN(A1))," ",REPT(" ",10)),10)+0

 

[Justinian]

Very nice!

Thank you!

 

[Eric W]

Glad to help!

 

[Rick Rothstein]

If there is always a $ sign, then maybe:

Worksheet Formulas Cell Formula B1 =LEFT(SUBSTITUTE(MID(A1,FIND("$",A1)+1,LEN(A1))," ",REPT(" ",10)),10)+0 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

A little shorter, one less function call...

=0+MID(LEFT(A1,FIND(" ",A1,FIND("$",A1))),FIND("$",A1)+1,99)

 

[Justinian]

Thank you!