=IF(ISNUMBER(A1),A1,"")

(Bob missed a closing paren.)

falcios wrote:

Thanks Bob

I copied the function on B2 and I got an error.
I am not familiar with this function. If my text starts in cell A1 what
should the function line read.

"Bob Phillips" wrote:

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






--

Dave Peterson