hi
thanks harmeet but in this case it only works with emailids ending with .com wht if iit ends with .net or .org or .in On Mon, Sep 7, 2009 at 6:12 AM, Daniel <dcolarde...@free.fr> wrote: > Hi. > > > > Can you attach a sample file to your reply ? > > > > Daniel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *ashish koul > *Sent:* dimanche 6 septembre 2009 18:00 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: help plz > > > > hi thanks > > i went through the site i am able to clean and trim but in below case i am > not abe to find the solution > > ashish k...@gmail.com..... result should be ashishk...@gmail.com > koulashish @gmail.com.......result should be koulash...@gmail.com > koul.ashish @gmail.com result should be koul.ash...@gmail.com > thanks > > > ashish > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
tt.xls
Description: MS-Excel spreadsheet