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!

First Aid : S190010

Unassigned : 9999999

Unassigned : 9999999

Unassigned : 9999999999

<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>

 

[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.