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<mailto: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