|
| 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 |
|
|
|
#1
December 29th 08, 02:34 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 17:35:36 -0800, "Andrew" wrote: If you have the default set up, Data is one of the options on the same line as the Home tab. If you then look at the section of the ribbon entitled "Data Tools", Text to columns is the first entry. 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? If you already have a method to put each email address into one cell by itself, I don't understand why you are asking the same question here.??? --ron Ron, thanks for your reply. I click "Text to Columns", and the dialog panel "no data was selected to parse" appears. I am unable to paste this entire string of email address, each address into one cell. I do able to paste the entire string into one cell. 
|
|
#2
December 29th 08, 03:12 AM
posted to microsoft.public.excel,microsoft.public.outlook
|
|||
|
|||
|
how to paste email address string into each cell in the spread sheet
On Sun, 28 Dec 2008 18:34:06 -0800, "Andrew" wrote:
"Ron Rosenfeld" wrote in message .. . On Sat, 27 Dec 2008 17:35:36 -0800, "Andrew" wrote: If you have the default set up, Data is one of the options on the same line as the Home tab. If you then look at the section of the ribbon entitled "Data Tools", Text to columns is the first entry. 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? If you already have a method to put each email address into one cell by itself, I don't understand why you are asking the same question here.??? --ron Ron, thanks for your reply. I click "Text to Columns", and the dialog panel "no data was selected to parse" appears. I am unable to paste this entire string of email address, each address into one cell. I do able to paste the entire string into one cell. Then the active cell (the cell which you selected before selecting "Text to Columns" is empty. --ron
|
| 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 |
Hybrid Mode
