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