First off, thank you to the experts in posting solutions to all our Excel issues!

I'm sure this issue has been presented before, but I am unable to locate the appropriate thread. I'm trying to program 2 data validation formulas for a single cell (A8). More specifically, I want to restrict a cell to only accept upper-case letters, and numbers. I do not want to allow a period (.).

What I have so far is:
=EXACT(UPPER(A8),A8),(SUBSTITUTE(A8,".",""))

My issue is I don't know how to connect the formulas. Is there a special character, like a (*), that might work to apply both formulas?

Thanks for the consideration!