Write a small macro in the excel sheet itself to do this taks. It would be very easy to handle in macros.
1. Take the column having the name
2. For each and every row, check if special char or number exist
3. It can be done by storing the cell value to an array
4. Parse the array and check if any special char or number exist
5. If the condition is met, means it should give a message
6. If the condition is not met, no need to give message
7. You will be done
1. Take the column having the name
2. For each and every row, check if special char or number exist
3. It can be done by storing the cell value to an array
4. Parse the array and check if any special char or number exist
5. If the condition is met, means it should give a message
6. If the condition is not met, no need to give message
7. You will be done