In B2, add

=IF(ISNUMBER(A3,A3,"")

and copy down.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"falcios" wrote in message
...
Sample text

TEST123
$100

TEST124
$200

TEST125
$300

How can I put the dollar amount values in a separate column [column b] on
the same line as text.

Thanks