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