Cell Contents to List

[jstevens]

Someone sent me a list of email addresses which was pasted to a cell in Excel. I need to be able to produce a list of those email addresses in columnar format.

The cell contents looks like: To: Addr01; Addr02; Addr03 and so forth. There are well over 100 email addresses.

I'm not sure how to being to parse the cell contents.

Any assistance would be appreciated,
John

[HansV]

Try the following:
- Select Data | Text to Columns or click Text to Columns in the Data tab of the ribbon, depending on the version of Excel,
- Specify Delimited, click Next, specify semi-colon, click Finish.
- Copy the horizontal list that is produced.
- Paste Special with the Transpose option.

[jstevens]

Hans,

It worked....never would have thought of text-to-column.

Regards,
John

[ChrisGreaves]

- Paste Special with the Transpose option.

Excellent!
I was able to pass this on to a colleague who would have balked at selecting the appropriate target area, and using Ctrl-Shift-Enter, not to mention (shudder) a function other than SUM or AVERAGE!