>Are you replacing the characters with a space or a empty string? It should be a space.
>
>Wait...
>
>I was doing it wrong. try this.
>
>
>c="W-4568S5B"
>? VAL(CHRTRAN(c,CHRTRAN(c,"0123456789",SPACE(100)),SPACE(100)))
>
>
>The CHRTRAN with default to a empty string if a coorisponding character in the third argument is not found.
Thanks, Greg. I may use this idea too.
If it's not broken, fix it until it is.
My Blog