Hi there, Hope you doing great!
This is in reference to your problem. Please follow the below listed steps. Select the Entire Column with the Data viz. A and then, Go To Data Click Text To Column Select Fixed Width then Click Next You'd see partial Data @ Data Preview Just Click over the scale and drag the pointer where you want the data to be seperated from. Click Next and Finish there you go you'd see the Phone no's and E-mails have been separated. *Note :* Please make sure you Keep the Next Column Vacant viz. If Data is in column A then Column B should be Empty. So guys hope I've tried my level best to explain em. Please be kind enough to share your suggestion and don't forget to keep me in Loop. Regards Mj's On Sat, Nov 8, 2008 at 10:43 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 > > > > -- ~ Me The Story Teller ~ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
