RE: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Great J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Krishna Kumar Sent: 17 September 2012 9:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula to Separate Company name and

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Shorter one. In D2 =TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2,FIND("@",A2)),CHAR(160)," ")," ",REPT(" ",99)),99))&LEFT(MID(A2,FIND("@",A2)+1,255)&" ",FIND(" ",MID(A2,FIND("@",A2)+1,255)&" ")-1) In E2 =TRIM(SUBSTITUTE(A2,D2,"")) Kris ExcelFox -- Join of

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Dear Jorge HI U can try this.. =TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("<>",A4))-1)," ",REPT(" ",99)),99)) If doesn't work share sample data. Cheers.. Regards//Vabs On Mon, Sep 17, 2012 at 8:49 PM, Jorge Marques wrote: > Hi, I´m sorry to be writing in this post, but I don´t thi

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi, I´m sorry to be writing in this post, but I don´t think it is necessary to open a new post, because I have the same problem but my mail is between <>, I can I extract this? thanks On 28 August 2012 14:53, vijayajith VA wrote: > Hi Zibrean,, > > Please use below formula > > =TRIM(RIGHT(SUBSTI

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Zibrean,, Please use below formula =TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("@",A4))-1)," ",REPT(" ",99)),99)) On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote: > > Hi Team, > > I am looking for a formula to separate Company's name and email address > from IDs. > > Please refer the

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

but it has more than 130 email addresses it is not possible manually... On Tue, Aug 28, 2012 at 5:28 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Hi Lucky, > > You can use text to column fuction and put delimited from @. Then you can > manually replace com/net etc. > > Pleas

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Lucky, You can use text to column fuction and put delimited from @. Then you can manually replace com/net etc. Please seperate the if two mail addresses in one cell. Regards, KSAGAR On Tue, Aug 28, 2012 at 4:40 PM, David Grugeon wrote: > Hi Noorain > > It seems easy enough to create a UDF

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Noorain It seems easy enough to create a UDF which finds the @ and then steps back until it finds a space. This will define the point to split the string. No time to do it at the moment. On 28 August 2012 20:39, Zibraan wrote: > > PFA... > > > On Tue, Aug 28, 2012 at 4:08 PM, NOORAIN ANSAR

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Sure zibraan, Can you share a sample sheet. On Tue, Aug 28, 2012 at 3:47 PM, Zibraan wrote: > ok atleast can we extract email address > > > > On Tue, Aug 28, 2012 at 3:01 PM, NOORAIN ANSARI > wrote: > >> Dear Zibraan, >> >> I think it is very difficult to separate company Name and ID. because

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Dear Zibraan, I think it is very difficult to separate company Name and ID. because criteria is changing with word by word. Excel Function can't recognize company name. If you provide specific criteria then it can be done. On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote: > > Hi Team, > > I a

$$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Team, I am looking for a formula to separate Company's name and email address from IDs. Please refer the snap shot below IDS Company Email Address Accord Soft asiapaci...@accord-soft.com