that number to the LEFT function as applied to A1, but have to
subtract 1 to prevent the inclusion of the "@"
Please let me know if you need the explanation broken down any more.
Regards - Dave.
From: anil.bha...@tatacommunications.com
To: excel-macros@googlegroups.com
Date: Fri, 18
groups.com] On
Behalf Of Dave Bonallack
Sent: Friday, March 18, 2011 3:28 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Remove text from a string
Hi,
If your text is in A1, try this in B1:
=LEFT(A1,SEARCH("~~",SUBSTITUTE(A1,"@","~~",LEN(A1)-LEN(SU
use substitute function
On Fri, Mar 18, 2011 at 1:46 PM, Deepak Rawat 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
>
> Reg
Hi,
If your text is in A1, try this in B1:
=LEFT(A1,SEARCH("~~",SUBSTITUTE(A1,"@","~~",LEN(A1)-LEN(SUBSTITUTE(A1,"@",""-1)
Regards - Dave
Date: Fri, 18 Mar 2011 13:46:12 +0530
Subject: $$Excel-Macros$$ Remove text from a string
From: deepakexce...@gmail.com
To: excel-macros@googlegroups.c
=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 wrote:
> Hi Masters,
>
> My query is to remove all the chara
