| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
All email addresses in one cell, how to seperate them?
I have many email addresses in one cell, how do I seperate them to
individual cells? Please help. Thanks. Mukesh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All email addresses in one cell, how to seperate them?
If they are separated by a common character such as a comma or a semi-colon,
you can use Text to Columns. Hopefully you don't have more addresses than columns your version of Excel will support. Regards, Fred. "Mukesh" wrote in message ... I have many email addresses in one cell, how do I seperate them to individual cells? Please help. Thanks. Mukesh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All email addresses in one cell, how to seperate them?
Hi Fred,
Yes, they are sepearted by a comma, how do I use Text to Columns? Thanks. Mukesh "Fred Smith" wrote: If they are separated by a common character such as a comma or a semi-colon, you can use Text to Columns. Hopefully you don't have more addresses than columns your version of Excel will support. Regards, Fred. "Mukesh" wrote in message ... I have many email addresses in one cell, how do I seperate them to individual cells? Please help. Thanks. Mukesh |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All email addresses in one cell, how to seperate them?
Ok I figured out Text to Column, how do I get Text to Rows instead of column? "Mukesh" wrote: Hi Fred, Yes, they are sepearted by a comma, how do I use Text to Columns? Thanks. Mukesh "Fred Smith" wrote: If they are separated by a common character such as a comma or a semi-colon, you can use Text to Columns. Hopefully you don't have more addresses than columns your version of Excel will support. Regards, Fred. "Mukesh" wrote in message ... I have many email addresses in one cell, how do I seperate them to individual cells? Please help. Thanks. Mukesh |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All email addresses in one cell, how to seperate them?
There's no such thing as Text to Rows in Excel.
After you've done the Text to Columns, you can transpose them into rows (copy, Paste SpecialTranspose) Regards, Fred. "Mukesh" wrote in message ... Ok I figured out Text to Column, how do I get Text to Rows instead of column? "Mukesh" wrote: Hi Fred, Yes, they are sepearted by a comma, how do I use Text to Columns? Thanks. Mukesh "Fred Smith" wrote: If they are separated by a common character such as a comma or a semi-colon, you can use Text to Columns. Hopefully you don't have more addresses than columns your version of Excel will support. Regards, Fred. "Mukesh" wrote in message ... I have many email addresses in one cell, how do I seperate them to individual cells? Please help. Thanks. Mukesh |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All email addresses in one cell, how to seperate them?
Got it!
One more thing....how do I remove the duplicates? Thanks. Mukesh "Fred Smith" wrote: There's no such thing as Text to Rows in Excel. After you've done the Text to Columns, you can transpose them into rows (copy, Paste SpecialTranspose) Regards, Fred. "Mukesh" wrote in message ... Ok I figured out Text to Column, how do I get Text to Rows instead of column? "Mukesh" wrote: Hi Fred, Yes, they are sepearted by a comma, how do I use Text to Columns? Thanks. Mukesh "Fred Smith" wrote: If they are separated by a common character such as a comma or a semi-colon, you can use Text to Columns. Hopefully you don't have more addresses than columns your version of Excel will support. Regards, Fred. "Mukesh" wrote in message ... I have many email addresses in one cell, how do I seperate them to individual cells? Please help. Thanks. Mukesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Outlook from starting when typing email addresses into a cell | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Email addresses in Excel need to format for mass email | Excel Worksheet Functions | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions | |||
Hybrid Mode
