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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
All email addresses in one cell, how to seperate them?
A common way is to count them. Anything more than 1 is a duplicate.
Something like: =countif(a:a,a1) and copy down. If you have XL2007, you can use Remove Duplicates on the Data ribbon. Regards, Fred. "ssignore" wrote in message ... Hi, Mukesh. I'm always trying to remove dupes, but I'm really cautious as to not delete too many. Try this: Insert a column and start at the top of your worksheet. Let's assume your e-mail addresses are in Column A. In the new column (Column B) enter the following formula: =IF(A2=A1,"Dupe",IF(A2=A3,"Dupe2","Single")) Which is essentially saying "Compare the contents of A2 to the row above and the row below and tell me if the contents is the same. If it's distinct, give me 'Single' and if it's a duplicate, then label Dupe and Dupe2." Then you can delete all that say "Dupe" and still keep the individual row that had the double. For example Column A Column B Dupe Dupe2 If you delete "Dupe", you will still have "Dupe2" or one row of . Hope this helps. Regards, ssignore "Mukesh" wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
All email addresses in one cell, how to seperate them?
But if you wipe out the rows that are 1, then you lose all duplicates and I believe Mukesh wants to keep one row. Also possible is a simple True/False where =A2=A3 Delete your "TRUE"'s and you continue to keep the row that originally had a duplicate. Regards, All. S "Fred Smith" wrote: A common way is to count them. Anything more than 1 is a duplicate. Something like: =countif(a:a,a1) and copy down. If you have XL2007, you can use Remove Duplicates on the Data ribbon. Regards, Fred. "ssignore" wrote in message ... Hi, Mukesh. I'm always trying to remove dupes, but I'm really cautious as to not delete too many. Try this: Insert a column and start at the top of your worksheet. Let's assume your e-mail addresses are in Column A. In the new column (Column B) enter the following formula: =IF(A2=A1,"Dupe",IF(A2=A3,"Dupe2","Single")) Which is essentially saying "Compare the contents of A2 to the row above and the row below and tell me if the contents is the same. If it's distinct, give me 'Single' and if it's a duplicate, then label Dupe and Dupe2." Then you can delete all that say "Dupe" and still keep the individual row that had the double. For example Column A Column B Dupe Dupe2 If you delete "Dupe", you will still have "Dupe2" or one row of . Hope this helps. Regards, ssignore "Mukesh" wrote: 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
All email addresses in one cell, how to seperate them?
Thank you Fred & Ssignore.
I think =countif will work better, since I will know if the email address is more than 1. "ssignore" wrote: But if you wipe out the rows that are 1, then you lose all duplicates and I believe Mukesh wants to keep one row. Also possible is a simple True/False where =A2=A3 Delete your "TRUE"'s and you continue to keep the row that originally had a duplicate. Regards, All. S "Fred Smith" wrote: A common way is to count them. Anything more than 1 is a duplicate. Something like: =countif(a:a,a1) and copy down. If you have XL2007, you can use Remove Duplicates on the Data ribbon. Regards, Fred. "ssignore" wrote in message ... Hi, Mukesh. I'm always trying to remove dupes, but I'm really cautious as to not delete too many. Try this: Insert a column and start at the top of your worksheet. Let's assume your e-mail addresses are in Column A. In the new column (Column B) enter the following formula: =IF(A2=A1,"Dupe",IF(A2=A3,"Dupe2","Single")) Which is essentially saying "Compare the contents of A2 to the row above and the row below and tell me if the contents is the same. If it's distinct, give me 'Single' and if it's a duplicate, then label Dupe and Dupe2." Then you can delete all that say "Dupe" and still keep the individual row that had the double. For example Column A Column B Dupe Dupe2 If you delete "Dupe", you will still have "Dupe2" or one row of . Hope this helps. Regards, ssignore "Mukesh" wrote: 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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
All email addresses in one cell, how to seperate them?
Is it possible to delete more than 1, instead of just knowing the number 1?
Thanks. Mukesh "Fred Smith" wrote: A common way is to count them. Anything more than 1 is a duplicate. Something like: =countif(a:a,a1) and copy down. If you have XL2007, you can use Remove Duplicates on the Data ribbon. Regards, Fred. "ssignore" wrote in message ... Hi, Mukesh. I'm always trying to remove dupes, but I'm really cautious as to not delete too many. Try this: Insert a column and start at the top of your worksheet. Let's assume your e-mail addresses are in Column A. In the new column (Column B) enter the following formula: =IF(A2=A1,"Dupe",IF(A2=A3,"Dupe2","Single")) Which is essentially saying "Compare the contents of A2 to the row above and the row below and tell me if the contents is the same. If it's distinct, give me 'Single' and if it's a duplicate, then label Dupe and Dupe2." Then you can delete all that say "Dupe" and still keep the individual row that had the double. For example Column A Column B Dupe Dupe2 If you delete "Dupe", you will still have "Dupe2" or one row of . Hope this helps. Regards, ssignore "Mukesh" wrote: 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 |