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:
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=LEFT(SUBSTITUTE(MID(A1,FIND("$",A1)+1,LEN(A1))," ",REPT(" ",10)),10)+0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

A little shorter, one less function call...

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

 

[Justinian]

Thank you!