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 <[email protected]> wrote: > Hi. > > > > Can you attach a sample file to your reply ? > > > > Daniel > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *ashish koul > *Sent:* dimanche 6 septembre 2009 18:00 > *To:* [email protected] > *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 [email protected]..... result should be [email protected] > koulashish @gmail.com.......result should be [email protected] > koul.ashish @gmail.com result should be [email protected] > 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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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
