Data validation and manipulating input

[MSXL]

Hello there, is it possible for Excel to check the length of data input is between 5 and 11 characters and if a "/" is detected, convert it into a " " (space)?

Also, is there a way to make sure any data input always appears correctly regardless of whether the user types 040922, 04/09/22, 04.09.22? 040922 converts to 12 04 1957. I need to be able to cover all eventualities as different people enter dates differently. I also need to anticipate some not using leading zeros.

I've tried setting data validation to text between x and x length but it doesn't throw an error if it's shorter or longer, is there a more reliable formula?

Thanks.