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
-~----------~----~----~----~------~----~------~--~---
