Remove numeric/characters values from a cell

[carov]

I have a file that has several columns that have alphanumeric values in them. I need to remove the numeric values plus the : from the file. What is the easiest way to do it?
Thank you!
[TABLE="width: 355"]
<tbody>[TR]
[TD]First Aid : S190010[/TD]
[TD]Unassigned : 9999999[/TD]
[TD]Unassigned : 9999999[/TD]
[TD]Unassigned : 9999999999

[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"></colgroup>[/TABLE]

 

[Gary's Student]

Try this small macro:

Sub dural()
    For i = 48 To 58
        Cells.Replace Chr(i), ""
    Next i
End Sub

 

[carov]

Thanks! That is what I needed.