How do you ...
 

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

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

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


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=468545

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

--Jim

"Dave Peterson" wrote in message
...
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

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 wrote:

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

--Jim

"Dave Peterson" wrote in message
...
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

--

Dave Peterson

Thanks man ... it worked!

--Jim

"Dave Peterson" wrote in message
...
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 wrote:

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

--Jim

"Dave Peterson" wrote in message
...
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

--

Dave Peterson