Hi,

I am not from programming background. I will be very gratefull if any excel mastermind look into this and write a macro.

I have a excelsheet with huge data (numbers and alphabets both). I need to clean alphabets from this database but keeping one. lets say...

When i am selecting column B, I need to clean all the alphabets but not A

When i am selecting column G, need to clean all the alphabets but not K

There will be numeric values as well, they should remain as it is but no cell will be having alpha-numeric values, either its numeric or alpha

column selection and alphabets may change with database. May be something like macro can give a popup where user can define which alphabet should remain as it is.

Will be highly obliged with any help.