Formatting database downloaded from internet

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Hi, all!

I'd like to download into Excel a database from the
internet. It's a list of newly formed business, with
column headings being date filed, name, file #, and
address. But the address ends up in two rows for each
record - the first row has the street address, and the next
row has the city, state and zip.

I'd like to have the city, state, zip cell show up in the
column to the right of the street address, instead of in
the row underneath. Another complication is that it looks
like the other fields - date, name, file # all take up two
rows, because the two rows have been merged together -
probably because the address is set up to take up two
rows...... I'd like to format these fields so that they
only take up one row, too, please.

Any suggestions, please?

FWIW, here's the web address that I'm downloading from.....:

http://papp2.co.washtenaw.mi.us/scripts/BusNames/BN_FSrch.pl

Also, any bright ideas on how I can get the owner into the
database, even though it's set up as a separate link on the
internet database - doesn't show the owner's name, just a
link button. Sure would be tedious to have to click on
each owner button.....

Please reply to my personal e mail - (e-mail address removed)

Thanks!!!!

Mary
 
No problem on the first but you're on your own with the links :-)

Bring the data in as you did. Select the whole sheet and do Format / cells /
Alignment / Uncheck Merged cells. Thsi will give you a blank line in between
every record.

I'll assume your address ended up in Col D, so copy Col D and paste it into Col
E, so you have two identical columns. Delete the cell E1, and choose to move
cells up, which will move the second part of the address in Col E in line with
the first part in Col D .

Select either of Col A/B/C, do Edit / Go To / Special / Blank Cells Only, and
then do Edit / Delete / Entire Row

Job Done, though if you want the address in a single cell you simply have to
concatenate Cols D&E.
 
Thanks, Ken! This worked perfectly!!!

Mary
-----Original Message-----
No problem on the first but you're on your own with the links :-)

Bring the data in as you did. Select the whole sheet and do Format / cells /
Alignment / Uncheck Merged cells. Thsi will give you a blank line in between
every record.

I'll assume your address ended up in Col D, so copy Col D and paste it into Col
E, so you have two identical columns. Delete the cell E1, and choose to move
cells up, which will move the second part of the address in Col E in line with
the first part in Col D .

Select either of Col A/B/C, do Edit / Go To / Special / Blank Cells Only, and
then do Edit / Delete / Entire Row

Job Done, though if you want the address in a single cell you simply have to
concatenate Cols D&E.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.766 / Virus Database: 513 - Release Date: 17/09/2004


.
Click to expand...
 
Back
Top