Untitled

[Derived Email] =
LOWER(
    REPLACE(
        REPLACE(
            REPLACE(
                REPLACE(
                    SPLIT([Line Item Owner Name], " ", 1), 
                    "'", ""
                ),
                "’", ""
            ),
            "-", ""
        ),
        ".", ""
    )
    + "." +
    REPLACE(
        REPLACE(
            REPLACE(
                REPLACE(
                    SPLIT([Line Item Owner Name], " ", -1), 
                    "'", ""
                ),
                "’", ""
            ),
            "-", ""
        ),
        ".", ""
    )
) + "@company.com"