Re: $$Excel-Macros$$ REPLACE

use this: =TRIM(LEFT(A5,27) & " " & RIGHT(A5,4) & " " & MID(A5,28,14)) *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Wed, Dec 23, 2015 at 12:24 PM, Vinod

$$Excel-Macros$$ REPLACE

Dear Team, PFA required your help in replacing the content from last to med. Regards, Vinod -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

Thanks Pankaj and others. It works fine. Thanks a lot pankaj. Im going to apply in my base data if any concern kindly help... Thanks Regards, Ganesh N On Tue, Dec 22, 2015 at 9:37 PM, Pankaj Sharma wrote: > Dear Ganesh, > > I hope it should be ok. > > > Sub lookup_list() > Dim wf As Objec

Re: $$Excel-Macros$$ Transform data - help required

Thanks a lot. It is great. Regards, Rashi On Tue, Dec 22, 2015 at 4:29 PM, Pankaj Sharma wrote: > okay, now check it > > > > *Pankaj Sharma * > > *MIS Analyst* > > *Greater Kailash-1, New Delhi* > > *Email * > *p ankaj123...@gmail.com > **Skyp

$$Excel-Macros$$ Fwd: Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

YouTube videos of U.S. Congress money laundering hearing of Saudi Billionaire " Maan Al sanea" with *bank of America* and The owner of Saad Hospital and Schools in the Eastern Province in *Saudi Arabia* and the Chairman of the Board of Directors of Awal Bank in *Bahrain* Wit

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

Dear Ganesh, I hope it should be ok. Sub lookup_list() Dim wf As Object: Set wf = Application.WorksheetFunction Dim list As Range: Set list = Range("A1", Range("A" & Rows.Count).End(xlUp)) Dim v1 As Long, v2 As Long, r As Long, a As Long, b As Long On Error Resume Next For

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

Dear Team, Thanks, But I not get the correct answer. I will say again in the column A I have the list of number. In column E I have some date. I want to check any one in the list (column A) is appearing in column E single cell. If cell E2 have the any number in Column A then i need the answer as

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

check it ! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N wrote: > Dear team, > > I want to find the any of the gi

RE: $$Excel-Macros$$ help on find the list matches to the cell part value

PFA. METABRAS Mihai Ghilea | Administrator retea T: +4(0) 268.407.410 | F: 0268.407.426 | M: 0728.994.113 A: Strada Grivitei A44, Cod postal RO500182 E: mihai.ghi...@metabras.ro W: 3W.METABRAS.RO http://www.metabras.c

$$Excel-Macros$$ help on find the list matches to the cell part value

Dear team, I want to find the any of the given list of value matches (part) in the particular cell using formula or macro. Please find the attached excel. If the solution in formula that would be great!! If you have any concern let me know. Thanks Team, Regards, Ganesh N -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Transform data - help required

okay, now check it *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 3:20 PM, Rashi Singh wrote: > Thanks. but it is not picking as per

Re: $$Excel-Macros$$ Transform data - help required

Thanks. but it is not picking as per my requirement sir. I have attached a file where i highlighted green, that is the format i require. Please find attachment. Regards, Rashi On Tue, Dec 22, 2015 at 2:35 PM, Pankaj Sharma wrote: > pfa > > > > *Pankaj Sharma

Re: $$Excel-Macros$$ Transform data - help required

pfa *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 22, 2015 at 9:28 AM, Rashi Singh wrote: > Hi, there some small changes in line item. Suppose