=--RIGHT(A1,SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))))


try this for the numbers.

"Dan B" wrote:

I copied some data from a report on a web page into excel.

The numbers have a " and a space in front of them, the dates have a ^ in
front. I tried find and replace and it didn't find these symbols. How can
I remove these? They are making my formulas not work because excel doesn't
recognize the numbers.

Thanks.