How to remove multiple email addresses

cannellonigreyh You can use this:

AddedCustom = 
    Table.AddColumn ( 
        PreviousStep, 
        "New Text", 
        each 
        Text.Combine ( 
            List.Select ( 
                Text.Split ( [Text], " " ), 
                each not Text.Contains ( _, "@" ) 
            ), 
            " " 
        ), 
        type text 
    )