I have some date in a column. Some of the data contains email addresses and some just text but this may contain an @ symbol.
I only want to keep the rows where there is an email address. I have tried using the Regex, but in essence I need it to be a negative regex, so the rows with “call me @ 12” are removed.
At present I use a simple filter, must contain @ but this does not work for the “call me @ 12”. Does anyone know how I can keep just the rows with a valid email address?