Stripping spaces from numbers

[TheBionicOrange]

I've got a column of numbers.
Each number is 19 digits long, and there are NO leading zeros.

Unfortunately, these numbers have intermittent spaces in the middle of them which I need to strip out.

e.g. 292 393 67675363 98769

I tried using the INSTR function, but that was giving me some weird results.

This is pretty urgent, so any input would be greatly appreciated.

Cheers

Steve

[Bruce Fox]

Here is a snippet from the VB Forum:

Dim intRowMax As Integer, intRowIdx As Integer
 
intRowMax = ActiveSheet.UsedRange.Rows.Count
 
For intRowIdx = 1 To intRowMax
    ActiveSheet.Range("A" & intRowIdx).Value = Replace(ActiveSheet.Range("A" & intRowIdx).Value, " ", "")
Next

Bruce.

[TheBionicOrange]

Ta

Anyone wanting any more results on this thread go here :

Other Thread !

.... as I was just too damn lazy to wait in the VBA forum

[opus]

Getting an answer in less than a hour, but still complaining!

[TheBionicOrange]

Originally posted by opus
Getting an answer in less than a hour, but still complaining!

I blame the wife ... I've been brainwashed !