Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Moving Rows to Columbus (Excel 2000)

    I have a list of addresses that I pasted into excel from a website that basically look like this:

    American Cheerleading Association
    5555 Spirit St
    Columbus, OH 43214
    800.555.5555


    Memphis All-stars
    555 Cheer st
    Memphis TN 55555
    999.555.5555

    (etc on and on for about 5000 addresses)
    and I need them to line up better - not like in a mailing format - but for a database: ( pretend that "/ "represents a column in excel)

    American cheer association/5555 Spirit St/Columbus/OH/43214/ ph#
    Memphis All-stars/ 555 Cheer St/ Memphis/TN/555555/ph #

    How do I do this? See example in attachment

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Moving Rows to Columbus (Excel 2000)

    Do all addresses in the real workbook have the same number of lines?

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving Rows to Columbus (Excel 2000)

    Yes, they do. I noticed that I omitted the phone number from my attached spreadsheet

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Moving Rows to Columbus (Excel 2000)

    Here is a solution that uses formulas. It assumes that the addresses are 5 rows apart (4 for the address, 1 blank row):

    In cell A1 of Sheet2, enter the following formula:

    =INDIRECT("Sheet1!A" & (ROW()-1)*5+COLUMN())

    Fill right to D1, then fill down to as many rows as you have addresses.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •