|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#5
December 28th 08, 01:35 AM
posted to microsoft.public.excel,microsoft.public.outlook
|
|||
|
|||
how to paste email address string into each cell in the spread sheet
"Ron Rosenfeld" wrote in message
... On Sat, 27 Dec 2008 08:11:26 -0800, "Andrew" wrote: Paste into some cell. Select that cell Data /Text to columns Delimited Select "semicolon" as the delimiter Finish Edit/Replace Replace what: ' (single quote) With: leave blank Replace All If you want these in a column, select the cells. Copy Select a destination (single cell which will be in the topmost row of the destination range) Paste Special: Transpose --ron Thank you Ron. I am using Microsoft Excel 2007. I cannot find Data/Text to columns Delimited? Also, when I paste, should I paste into entire row instead of one cell, then, each email address will put into one cell by itself? 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| search for string of contacts by a string of email addresses | Kerm Rudgeon | Outlook - Using Contacts | 2 | October 21st 08 07:51 PM |
| updating email address field from in-cell editing (table view) | Rafael | Outlook - General Queries | 2 | May 31st 07 01:08 AM |
| Using a spread sheet for e-mail addresses | Len Urban | Outlook - General Queries | 5 | January 19th 07 04:30 PM |
| Send email to email addressess in Excel Sheet | Darrell | Outlook - Using Contacts | 2 | September 18th 06 12:20 PM |
| Need String from Email Subject | CondtllyFrmttd | Outlook and VBA | 1 | January 25th 06 04:26 PM |
Threaded Mode