Hi Aligah, Nicely explained query, though little lengthy but it's ok and well drafted. I have solved the attached workbook as per your criteria.
Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/1/09, Aligahk06 <aligah...@gmail.com> wrote: > > Dear All, > > Greetings of the day!!!!! > I have an excel file with bulk of contents in following format. > Col A contains description, Colc Contains (Size inches to the > corresponding description) > Col D contains the Qty. to the corresponding Description. > > I want to fetch form ColA i.e( Only Pipe and ELL as a text from entire > string.) > i.e if pipe is available in string then fetch it or if ELL is > available in same string then fetch it. > But in each string only either pipe will bet there or ELL will be > there or nothing. > Possibilty of finding the string is One( i.e either pipe or ELL not > both in same string.) > > From column C the corersponding inches i want to fetch. > From column D the corersponding Qty. i want to fetch. > > From All three columns appear contents respectively in ColE, COlF and Col > G. > > Basically this is for compilation of requisite data only. > Note:- The excel file is converted from Pdf file. > > Please assist with any formula or macro or the logic you can share. > Rgds, > Aligahk06 > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
Query-Extracting Text- By DILipandey.xls
Description: MS-Excel spreadsheet
