Dynamic array to pull dollar amounts

[Stephen_IV]

I have this string in A1

I have $3000 dollars and Jim collected $65.03 dollars. Gina went to the Casino and lost $875.78 and Joe's vacation cost him $9876.54. There were 111 cars on site. I am looking to pull only the dollar amounts. so far I have =TOCOL(IF(LEFT(MID(A1,SEQUENCE(LEN(A1)),8),1)="$",MID(A1,SEQUENCE(LEN(A1)),8),1/0),3) But I am missing num_char, any help would be appreciated.

 

[shaowu459]

I didn't see your expected results, so how about this one:

工作簿1
	A	B	C	D	E	F
1	I have $3000 dollars and Jim collected $65.03 dollars. Gina went to the Casino and lost $875.78 and Joe's vacation cost him $9876.54. There were 111 cars on site.
2
3		3000
4		65.03
5		875.78
6		9876.54
7
8
Sheet1

Cell Formulas
Range	Formula
B3:B6	B3	=DROP(TAKE(TEXTSPLIT(A1&" ",{". "," "},"$"),,1),1)
Dynamic array formulas.

 

[Stephen_IV]

shaowu459 that will do it! Thank you so much! That is exactly what I needed!​

 

[shaowu459]

shaowu459 that will do it! Thank you so much! That is exactly what I needed!​

glad we could help and tanks for the feedback