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
--
=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.comwrote:
Hi Masters,
My query is to remove all the
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.com
Hi
use substitute function
On Fri, Mar 18, 2011 at 1:46 PM, Deepak Rawat deepakexce...@gmail.comwrote:
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
] 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(SUBSTITUTE(A1,@,-1)
Regards - Dave
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 Mar 2011 16:05:23 +0530
Subject: RE: $$Excel-Macros$$ Remove text from a string
Amazing Daveā¦ very well answered