HomePro
Board Regular
- Joined
- Aug 3, 2021
- Messages
- 157
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Prefer Not To Say
- Platform
- Windows
- MacOS
- Mobile
- Web
I have a list of email addresses. Some are two or three to a cell. They are separated by either a space or a comma or a semicolon.
I would like to separate all the addresses into one list of 1 address per cell. I have tried a few formulas but they do not work across all the variations.
Can anyone help?
I would like to separate all the addresses into one list of 1 address per cell. I have tried a few formulas but they do not work across all the variations.
Can anyone help?