Hello Smartsheet Community Friends!
I am looking for a formula that would allow me to extract just an email address from a cell that contains text. Example, the cell in column "Notes" might contain:
'blah blah words blah myemail@email.com more words blah blah'
I am looking for a formula that would help me extract that email address and copy into a new "Email" column
I am thinking this would be a lookup for @ and then taking all text left or right of that up to the space, but I don't know how I could write that. Does anyone have experience with that?
Thanks!! ✌️