Hi all, I have a text string in cell A1 of about 150 email address (each one seperated by a colon
I want to be able to split each email address into a different row, so the first one in Cell A1, second address in A2, third in A3 etc.
Is there a way to do this without manually chopping and pasting?
I'm sure there's an easier way... but I would recommend taking the single, long string, and putting it into a text file. From there, use the Data > Import from text. Choose Delimited with Semicolon separations.
It'll end up being a ton of data within row 1, rather than in 1 column like you asked. So select all of the e-mails across row 1, and cut, Paste Special, and select Transpose at the bottom of the paste special menu, that will swap the X and Y axis, and get them in the way you're looking for.
I '<3' reputation. If I helped, click the scales. This will be helping an internal departmental competition with co-workers.
Reputation can be granted through the Scales Icon (for classic layout), or the little Star on the bottom of the post next to the blogging function for the new forum layout.
If you're not busy, and really feel down on life, read my excel blog which may or may not have contents.
This approach is minimally manual
• Select cell A1
• Data.Text-to-Columns
...Check: Delimited.........Check: Next
...Check: Semicolon
...Click: Finish
That will put each email address in A1, B1, C1...etc
• Select B1:EU1
• Home.Copy
• Select cell A2
• Home.Paste(dropdown)....Click: Transpose
Now the addresses are in A1:A150
Is that something you can work with?
Last edited by Ron Coderre; 06-30-2011 at 10:42 AM. Reason: Made instructions more specific to XL2007
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks