=LEFT(A1,FIND("@",A1,FIND("@",A1)+1)-1)
or
=MID(A2,1,FIND("@",A2,FIND("@",A2)+1)-1)
of
array formula
=LEFT(A3,MAX((MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1)="@")*ROW(INDIRECT("1:"&LEN(A3))))-1)On Fri, Mar 18, 2011 at 3:16 PM, Deepak Rawat <deepakexce...@gmail.com>wrote: > Hi Masters, > > My query is to remove all the characters after the last "@" from the text. > > Example: > The Raw test is > deepak@gmail.comkaml...@yahoo.com > > The final text i want is deepak@gmail.comkamlesh > > Regards, > Deepak Rawat > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
