All 200 are pasted into one cell?

If that number is always less than 255, you can select that cell.
Data|text to columns
delimited
by semicolon
and finish up

If you want to make that list vertical instead of horizontal, you can
select those cells
edit|copy
come down to A2 (just out the original data range)
edit|Paste special|check transpose

(and delete the original stuff.)

Spike9458 wrote:

take a bunch of data from one cell, and put it into columns?

I have a couple hundred email addresses that, when I copy them from the
email, they only paste into one cell. I would like to put each address into
its own column ... but can't figure it out ... but it looks like this:

; ; .....................

Thanks in advance!

--Jim

--

Dave Peterson