Hello Excel Experts! I have been all over the forum with various keyword searches and all I have come up with as an answer to my question doesn't answer my need for a formulaic approach to this problem (e.g., Data > Text to Columns is manual and I need formulaic). I would have thought this to be easy, but based on my searches, it's been elusive. Your help will be greatly appreciated.
All I need to do is - with a formula - take two email addresses separated by a semi-colon in one cell and extract them both individually into two separate cells.
Could you help? Thank you!