Multiple email addresses in one cell to vertical column

[frede1984]

We have a mess...

We are using the newest version of excel on windows platform and have a massive list of email addresses that are unfortunately combined into one column in excel, the largest combination containing 157 email addresses in one column cell. Our objective is to move all of the email addresses into a list in one column.

I have already performed text to columns to segment the data but that creates its own separate issue of the data being in 157 individual columns by 165,000 rows... From this point I have attempted the TRANSPOSE function but my fingers are work out copying and pasting the function - THERE HAS TO BE A BETTER WAY!

Here is a small sample of the data prior to text to column, keep in mind there are over 165,000 rows

Any and all help is greatly appreciated - Cheers!

"Aguilar, Vincent" <vaguilar@tttlconstruction.net>, "Dispatch Central" <dispatch@911dispatching.net>

"'Aguilar, Vincent'" <vaguilar@tttlconstruction.net>, Lewis Schulze <LewisS@lyeconstruction.net>

"'Aguilar, Vincent'" <vaguilar@tttlconstruction.net>, Lewis Schulze <LewisS@lyeconstruction.net>

"'Aguilar, Vincent'" <vaguilar@tttlconstruction.net>, dispatch <dispatchcvc@lyeconstruction.net>

"'Aguilar, Vincent'" <vaguilar@tttlconstruction.net>, dispatch <dispatchcvc@lyeconstruction.net>

"'admin@alliancereadysledinc.net'" <admin@alliancereadysledinc.net>, "'To:'" <'keith@alliancereadysledinc.net'>

"Accounts Payable (lyeconstruction)" <ap@lyeconstruction.net>, Keith Railey <keithr@lyeconstruction.net>

"accounting@tateshass.net" <accounting@tateshass.net>, "sam@tateshass.net" <sam@tateshass.net>

"accounting@select22mementhasals.net" <accounting@select22mementhasals.net>, "davidv@select22menthasals.net" <davidv@select22menthasals.net>

"adam@22.net" <adam@22.net>, "rosalinds@22.net" <rosalinds@22.net>, Rebecca Unruh <RebeccaU@lyeconstruction.net>, Angela Ochoa <AngelaO@lyeconstruction.net>

"accounting@select22mementhasals.net" <accounting@select22mementhasals.net>

"50d1-orders@tim.net" <50d1-orders@tim.net>, "bwyant@tim.net" <bwyant@tim.net>, "msclark@tim.net" <msclark@tim.net>

"50d1-orders@tim.net" <50d1-orders@tim.net>, Eric Jung <ejung@tim.net>

"accounting@tateshass.net" <accounting@tateshass.net>, "sam@tateshass.net" <sam@tateshass.net>, "joe@tateshass.net" <joe@tateshass.net>

"accounting@select22mementhasals.net" <accounting@select22mementhasals.net>

"Aguilar, Vincent" <vaguilar@tttlconstruction.net>, "Shaw, Daniel" <DShaw@tttlconstruction.net>, Dispatch Central <dispatch@911dispatching.net>

"Aguilar, Vincent" <vaguilar@tttlconstruction.net>, "Dispatch Central" <dispatch@911dispatching.net>, "Shaw, Daniel" <DShaw@tttlconstruction.net>

"'Abacus Surveying (abacusurvey@aol.net)'" <abacusurvey@aol.net>, 'Tony' <tonys@lyeconstruction.net>, "Brianda Espinosa (bespinosa@espls.net)" <bespinosa@espls.net>, Jeff Cissell <jcissell@bmeng.net>

"Aguilar, Vincent" <vaguilar@tttlconstruction.net>, "Dispatch Central" <dispatch@911dispatching.net>

Note email addresses are fictitious.

 

[DRSteele]

I think most people would suggest you use Power Query to clean all that data. Trying to use formulas will drive you into the madhouse.

 

[frede1984]

I think most people would suggest you use Power Query to clean all that data. Trying to use formulas will drive you into the madhouse.

AWESOME! Did not even know this existed - thank you