If there is space between tel no & e-mail id,: 1. Go to data menu 2. Select text to colmuns 3. Select delimited 4. Click on next and select space 5. Click next and then finish
Ur data will be seperated. On Nov 8, 10:13 am, [EMAIL PROTECTED] wrote: > In excel,i have a column having the phonenumber and emailid(both in > the same column) how to split into 2 ? > please help me to split the phone number and email id into two > different columns.... > example : [EMAIL PROTECTED] in column A ,is to be separated as > 0998786751 in column B and [EMAIL PROTECTED] in column C > note:the length of phone number and email id may vary... > Give me a formula or a macro.. > i have 1000's of record like this to split --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
