Excel Help

[xcaliber13]

Ok it's Monday Morning and I am just at a complete blank to do this:

I have an excel column that should only have numbers in each cell.  Always a 4 digit number.   But some of the cells get pulled into excel with letters in this column.

Can someone point in the direction I should look to?

Cells look like this:

LLE     2256

N M    2267

M     2298

Need them to look like this:

2256

2267

2298

Basicly delete the letters, keep the numbers.    Just totally blank on how to begin.   Thanks

[xcaliber13]

Ok so I have tried this:

For $i = 1 To $iLastRow
    $iCell = _Excel_RangeRead($oWorkbook, Default, "H" & $i)
    If $iCell > "" Then StringRegExpReplace($iCell, "[A-Za-z]", "")

Next

This code does not work.    Is this not a regex problem?     Should I look to do something else? 

Thank you

[water]

Define "Does not work". How do you know that it doesn't work?

[AutoBert]

 

the result is never written back to the excel cell.

 

[JLogan3o13]

StringRegExpReplace doesn't inherently know what you want to do with the returned value. Have you tried something like:

_Excel_RangeWrite($oWorkbook, Default, StringRegExpReplace($iCell, "[A-Za-z]", ""), "H" & $i)

 

[xcaliber13]

OK!   Thank you everyone for getting me on the right Track.    I got it to work.

This works:

For $i = $iLastRow To 1 Step -1
    $iCell = _Excel_RangeRead($oWorkbook, Default, "H" & $i, 3)
              $sCell = StringRight($iCell, 4)
              _Excel_RangeWrite($oWorkbook, Default, $sCell, "H" & $i)
        Next

Again a big thank you all

[water]

If performance is an issue then I suggest to use _Excel_RangeRead to read the whole column in one go into an array, modify the array and then rewrite the whole column from the array.
That's much faster!

[xcaliber13]

Water,

           Would I then use _ArrayTrim?

[water]

If you have always to remove the same number of characters from the left then _ArrayTrim could be a solution.