Replacing comma with dot in large data sets

Hi All

I am currently working on saving some SAP BW queries in excel as text files.
However, I have a problem, some columns out as "0,000" or "0,0000" which makes the save text file also uses the "" which is not allowed in our load code.
We can not change the source format i.e. "0,000", but if we replace the comma with a dot or blank, then the text file is correct (without any "").

So my question is how do I effectively remove the comma and replace with either blank or a dot ?
I have a quite large data set, around 15 columns with each 50.000 cells (around 750.000 cells!)

I also have to remove spaces in the cells, using the following (peusdo code):
set rng= range("A1:A4"")
rng.value=application.trim(rng)

Could something similar be possible using the application. function ?

Since the data set is so large, looping though all cells is too slow. I have tried something similar to below code, and it is very too slow:
Range("A1:A6").Select
Selection.Replace What:=".", Replacement:=".", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False



Br,
Simon

I used this with 90k rows, it was pretty darn quick.

Please Login or Register  to view this content.