Data validation does not adjust values to the given specs, it only prevents you from entering something that doesn't comply with the validation rule. So don't use that for abbreviating names.

Please answer Evolta's question to clarify what results you want