Hi Bryan/Harris, I think an intelligent use of "Text - to - column" feature of MS-Excel will do the task. can you attach the sample file for the group to have a try on it. Thanks.
-- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sat, Sep 26, 2009 at 1:15 AM, BMWFLYBOY <bryan.harris....@gmail.com>wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
