excel vba manipulating cells

[golki]

---

Need your help mga boss about excel programming. Naa koy ge copy paste nga data from our SAP GUI to excel. Ang purpose lang sa program is to automate some calculations(summation, mult etc.). Ang data nga ma paste nako contains combination of space and numbers. (ex. A1 contains ___12.00__), and blank space for empty values(A2 is _____). Now the problem is pag gammit nako ug function sa excel like =sum(A1:A2) dli cya mu return ug value kay dman numbers ang sulod sa cell.

i tried functions like trim(), int(cell(1,1).value), pero di gehapon mu return ang =sum() nga function. unsa may inyu ma suggest nga code?


Salamat!

[omelsoft]

Murag karaan na kaayo ni post dah? hehe

By the way bro, before doing any calculations you need to remove extra characters you don't need. like the underscores.
If you're using Excel 2007 or earlier.
Go to Data Tab> Choose Text to Columns> then pwede na nimo ma format ang data and remove the unnecessary characters.
Pwede nimo maseparate tanan numbers from characters.