Hi, Send me the file i will try to solve it. But give me the original file for getting the correct pattern and exception.
If you can't send the file to this group then send me on sandymau...@gmail.com. Regards Sandeep ----- Original Message ----- From: "BMWFLYBOY" <bryan.harris....@gmail.com> To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Sent: Saturday, September 26, 2009 1:15 AM Subject: $$Excel-Macros$$ parsing multi line data I have data entries that take up three lines here is an example: LIC # BUSINESS NAME ISSUED TYPE CLASSIFICATION BUSINESS ADDRESS OWNER NAME & ADDRESS BUS PHONE # ------------------------------------------------------------------------------------------------------------------------------------ 10-00005319 #1 DRAGON HOUSE 5/11/09 RNW RESTAURANT/ BAR 1799 KIOWA AVE 112 LEE, CHUNG BOU 928-505-8367 LAKE HAVASU CITY AZ 86403 448 SUNFIELD DR, LAKE HAVASU CITY AZ 86406 10 00020531 AMERICAN PACIFIC MORTGAGE 8/10/09 NEW SERVICE: MORTGAGE BANKER BRANCH #53 MYERS KEVIN & JENSEN TWYLA 928 854 2053 60 ACOMA BLVD S B100 60 ACOMA BLVD S B 100 LAKE HAVASU CITY AZ 86403 LAKE HAVASU CITY AZ 86403 10-00007286 #1 NAILS EXPERT & MORE 1/14/09 RNW SERVICE: NAIL SALON 34 LAKE HAVASU AVE N 8 VU, VIET HUNG & PHAN, MICHELLE 928-854-6080 LAKE HAVASU CITY AZ 86403 34 LAKE HAVASU AVE STE 8, LAKE HAVASU CITY AZ 86403 10-00015642 #1 NAILS EXPERT & MORE 2/05/09 RNW SERVICE: NAIL SALON 1460 BENTLEY BLVD NGUYEN, ANH 928-680-1899 LAKE HAVASU CITY AZ 86403 1451 BENTLEY BLVD, UNKNOWN AZ 10-00015643 #1 NAILS EXPERT & MORE 2/05/09 RNW SERVICE: NAIL SALON 1850 MCCULLOCH BLVD N C3 NGUYEN, ANH 928-680-1699 LAKE HAVASU CITY AZ 86403 1460 BENTLYE BLVD, LAKE HAVASU CITY AZ 86404 10-00004380 #1 NAILS EXPERT & MORE INC 1/05/09 RNW SERVICE: NAIL TECHNICIAN 2231 MCCULLOCH BLVD N 102 #1 NAILS EXPERT & MORE INC 928-854-7100 LAKE HAVASU CITY AZ 86403 2231 MCCULLOCH BLVD N STE 102, LAKE HAVASU CITY AZ 86403 10-00020217 "HANDS ON" THERAPEUTIC MASSAGE 5/06/09 NEW SERVICE: MASSAGE THERAPY 645 MANZANITA DR BERGER, BONNIE LYNNE 928-208-3858 LAKE HAVASU CITY AZ 86404 645 MANZANITA DR, LAKE HAVASU CITY AZ 86404 10 00013426 AMEC EARTH & ENVIRONMENTAL INC 1/20/09 RNW SERVICE: ENGINEERING 10706 SIKES PL STE 250 AMEC EARTH & ENVIRONMENTAL INC 928 854 8030 CHARLOTTE NC 28277 10706 SIKES PL STE 250 CHARLOTTE NC 28277 I would like to be able to parse everything in each entry, I have been trying to do this for days but can't get any real good results. I don't know much about this programming stuff so I beg and plead with all of you to help me find a solution. The placement is exactly as it shows in the file so almost nothing lines up correctly. So I can't do text to columns. Ideally I would like each bit of info in it's own column: LIC #/BUSINESS NAME//ISSUED//TYPE//CLASSIFICATION//BUSINESS ADDRESS// OWNER ADDRESS...ETC Thanks for your time and please please please be kind enought to help me out!!!!! thanks! -BMWFLYBOY --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 -~----------~----~----~----~------~----~------~--~---