A formula written to create an email ready string based on the special character formatted values from separate first and last name fields.

Special Character Email Creation.txt

IF(
    AND(
        {first_name},
        {last_name}
    ),
    IF(
        REGEX_MATCH(
            TRIM({first_name}) & TRIM({last_name}),
            "[áàâåæçèéëêîïìñôöòøõùûüýíúşó]"
        ),
        REGEX_REPLACE(
            REGEX_REPLACE(
                REGEX_REPLACE(
                    REGEX_REPLACE(
                        REGEX_REPLACE(
                            REGEX_REPLACE(
                                REGEX_REPLACE(
                                    REGEX_REPLACE(
                                        REGEX_REPLACE(
                                            REGEX_REPLACE(
                                                REGEX_REPLACE(
                                                    REGEX_REPLACE(
                                                        REGEX_REPLACE(
                                                            TRIM(LOWER({first_name} & "." & {last_name})),
                                                            "ó", "o"
                                                        ),
                                                        "ş", "s"
                                                    ),
                                                    "ú", "u"
                                                ),
                                                "í", "i"
                                            ),
                                            "ý", "y"
                                        ),
                                        "[ùûü]", "u"
                                    ),
                                    "[ôöòøõ]", "o"
                                ),
                                "ñ", "n"
                            ),
                            "[îïì]", "i"
                        ),
                        "[èéëê]", "e"
                    ),
                    "ç", "c"
                ),
                "æ", "ae"
            ),
            "[áàâå]", "a"
        ),
        TRIM(LOWER({first_name} & "." & {last_name}))
    )
)