RE: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-16 Thread Dilip Pandey
---Original Message- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: Saturday, October 15, 2011 09:59 PM > To: excel-macros@googlegroups.com > Cc: Noor Ali Sayyed; Anil Bhange > Subject: Re: $$Excel-Macros$$ Formula needed to extract the text from > string > &g

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread Dilip Pandey
om: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Anil Bhange > Sent: Wednesday, October 12, 2011 04:14 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Formula needed to extract the text from string > > Amazing... Ms-Ex

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread ashish koul
l-macros@googlegroups.com] *On Behalf Of *Ms-Exl-Learner . > *Sent:* Wednesday, October 12, 2011 03:34 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Formula needed to extract the text from > string > > ** ** > > Hi Anil, > > ** ** &g

RE: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread Anil Bhange
PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Formula needed to extract the text from string Amazing... Ms-Exl-learner... This is exactly what I wanted... I was pretty sure this forum only can help me with solution... Thanks once again.. this saves my lot of time... Regards

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-12 Thread Dilip Pandey
Hi Anil, Designed a formula using Substitute function. See the attachment and let me know if this helps. Regards, DILIPandey On 10/12/11, Anil Bhange wrote: > Hi Expert, > > I needed the formula which can extract the specific content from a Text, > below is some sample excel cells > > To simpl

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-12 Thread Haseeb Avarakkan
Hello Anil, A short version to Ms.Exl.Learner =TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",255)),4*255,255)) HTH Haseeb For help & tips visit; http://www.excelfox.com/forum/forum.php -- -- Some important links for excel u

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-12 Thread Ms-Exl-Learner .
t; > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ms-Exl-Learner . > *Sent:* Wednesday, October 12, 2011 03:34 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Formula needed to extract the t

RE: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-12 Thread Anil Bhange
-macros@googlegroups.com] On Behalf Of Ms-Exl-Learner . Sent: Wednesday, October 12, 2011 03:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula needed to extract the text from string Hi Anil, I Assume that your data is in Column A and your first row is having the column

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-12 Thread NOORAIN ANSARI
Dear Anil, See attached sheet if it help to u.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Oct 12, 2011 at 1:20 PM, Anil Bhange < anil.bha..

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-12 Thread Ms-Exl-Learner .
Hi Anil, I Assume that your data is in Column A and your first row is having the column header. So your data will start from 2nd row of Column A (i.e. from A2 cell) A1 Data A2 /ENTRY-10 OCT TRF/REF 6004ABS6834230 /ORD/ Q-FAST TELECOM BV STRIJKVIERTEL 26 A 3454 PMDE MEERN /BNF/ INVOICENO 201