Using the below I'm able to get just the first email from C1, but no emails from the subsequent cells. I need to be able to get all the emails from all the cells. How do I modify this to work on the next cells also? (C2 to C4)?
(I found part of a solution here But it's only able to get an email from one cell).
=iferror(Regexextract(test!C1:C4,"[A-z0-9._%+-]+@[A-z0-9.-]+\.[A-z]{2,4}"),"")
Here's my test Google Sheet: https://docs.google.com/spreadsheets/d/1_VEdYMSfgFWLvyyFa99xWLNsH6YBgZrcncG4neSvXhE/edit?usp=sharing
