Splitting addresses from outlook into cells

[kestrel]

Hi,

I want to get a list of email addresses from outlook into separat
cells in Excel.

So my data is like this:

(e-mail address removed); (e-mail address removed); (e-mail address removed) etc. etc. (there ar
about 50 addresses in total).

How do I get Excel to sperate these cells using the ";"?

Thanks

Kestre

 

[kestrel]

Just remembered how to do it:

Data / Text to column