Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|