If I have a column that has both numbers and words is there a way to
replace the words with an alternate value? For example the column may
read:

123456
1234567
adam
4569
eve
111-111

If I were to sort the above column the "adam", "eve", and "111-111"
would sort as words and not numbers obviously.

I want to write a macro to look at the column and take all of the word
entries, ignore the numbers and replace with another word, in this
case "Check". When finished the above would read:

123456
1234567
Check
4569
Check
Check

I found some references here about isnumeric and istext and variations
of this but I was not able to make it work for what I was attempting.

Thanks for any help.