In a helper column
=IF(ISNUMBER(C2),C2,LEFT(C2,FIND(" ",C2)-2)+RIGHT(C2,LEN(C2)-FIND(" ",C2)))

--
Don Guillett
SalesAid Software

"bijan" wrote in message
...
I have a huge data that some of them contain wrap text cells with number
value,
how I can sum this example correctly with macro?
A B
1 10
20
2 54
3 3365
18
4 524