| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 | |
|
|
Hybrid Mode
