I want to check a excel file and throw out email addresses which are entered like these formats

1) a@a..com
2) b@a.com.
3) a b@a.com
4) na
5) n/a