Is there a possibility for a formula solution?

Assuming source data in A1 down
Try in say, B1: =SUBSTITUTE(SUBSTITUTE(A1," ",""),",","")+0
Copy down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--