For­mu­la for extract­ing email from Out­look copy paste (e.g., Smith, John [Org] <john.smith@org.ca>)

=MID(text, start_num, num_chars)

=MID(
A2,
SEARCH("<", A2) + 1,
SEARCH(">", A2) - SEARCH("<", A2) - 1
)

Extract­ing domain from email (e.g., Smith, John [Org] <john.smith@org.ca>)

=MID(
A2,
SEARCH("@", A2) + 1,
SEARCH(">", A2) - SEARCH("@", A2) - 1
)