How do you ...

[Spike9458]

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:

(e-mail address removed); (e-mail address removed); .....................

Thanks in advance!

--Jim

 

[Dave Peterson]

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.)

 

[bill k]

go to
data
text to columns
delimited
;
destination (in the next column say .........B2?)

take a copy of the wrkbk before you start and have a go.......

 

[Spike9458]

Hey Dave, that worked great ... how do I get rid of the space that preceeds
each email address?

--Jim

 

[Dave Peterson]

Can you put the data back into a single cell?

If yes, do the data|text to columns, but specify both the space character and
the semicolon. (And make sure "Treat consecutive delimiters as one" is checked.

If you already have the data in a single column (some with leading spaces):

Select that range
data|text to columns
This time choose fixed width
Remove any lines that excel guessed (and don't add any yourself)
and finish up.

 

[Spike9458]

Thanks man ... it worked!

--Jim

Can you put the data back into a single cell?

If yes, do the data|text to columns, but specify both the space character
and
the semicolon. (And make sure "Treat consecutive delimiters as one" is
checked.

If you already have the data in a single column (some with leading
spaces):

Select that range
data|text to columns
This time choose fixed width
Remove any lines that excel guessed (and don't add any yourself)
and finish up.