Hi,

Try this but it's still text

=MID(A1,FIND("$",A1),999)

or this to drop the $ sign

=MID(A1,FIND("$",A1)+1,999)

Mike

"dstiefe" wrote:

Remaining Balance on Invoice: $1,000.00

the text above is in a cell..i have thousand of cells in column like this

how do i capture just the "$1,000.00" amount. because this amount is
sometimes a 1,000 and sometimes 10,000

Thank you