Dear Anil, See attached sheet if it help to u..
-- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> On Wed, Oct 12, 2011 at 1:20 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi Expert,**** > > ** ** > > I needed the formula which can extract the specific content from a Text, > below is some sample excel cells**** > > ** ** > > To simplify this there is “/” sign after each content, and I need exact > data which *start after 4th “/” and till 5th “/”* (which is mention below > in Red).**** > > ** ** > > Can anybody tell me the formula.**** > > ** ** > > ** ** > > ** ** > > /ENTRY-10 OCT > TRF/REF 6004ABS68300004230 > /ORD/* Q-FAST TELECOM BV STRIJKVIERTEL 26 A 3454 PM > DE MEERN */BNF/ INVOICENO 2011000000247 ACCOU > NTNO 019481**** > > /ENTRY-10 OCT > TRF/REF 6004ABS68300014073 > /ORD/* U-WISS CONSULTANCY OUDAEN 26 LELYSTAD */BNF/ > 201100000279 TRANSACTIEDATUM 10-10-2011**** > > /ENTRY-10 OCT > TRF/REF 6004ABS68300025023 > /ORD/* U-WISS CONSULTANCY OUDAEN 26 LELYSTAD** */BNF/ > 201100000295 TRANSACTIEDATUM 10-10-2011**** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > *Anil Bhange* > > *Assistant Manager* > Financial Reporting & Compliance,**** > > TATA Communications Ltd. > VSB, Fort, Mumbai – 400 001, > India**** > > ** ** > > ' Desk : + 91 22 6659 2320 > | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 **** > > anil.bha...@tatacommunications.com**** > > ** ** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
See it if help.xls
Description: MS-Excel spreadsheet
