+ Reply to Thread
Results 1 to 2 of 2

Format Change For Contact Information

  1. #1
    Registered User
    Join Date
    07-11-2007
    Posts
    1

    Format Change For Contact Information

    Hi,
    I'm relatively new to excel and i'm not sure if my question belongs here or in programming so i apologize ahead of time if i am wrong. i have contact information as follows:

    Name
    address
    city, state zip

    All data entered in column A and sometimes 'address' can be 2 or 3 more lines before the City state line. All info is text. my question is how do i convert the vertical mailing style contact info into a more manageable format as follows:

    Name Address City StateZIP State
    (repeat state for organization)

    With Name in A, Address in B and so on. My ultimate purpose is to better organize this data and to put it into mailing label form for Word to print.

    Thank you for taking the time to read my post, it is much appreciated.

    -AY

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075
    You can transpose column data to a row and vice versa. Select one of the address blocks and copy, then move your cursor into an empty column and click on Edit, Paste Special and select Transpose. Make sure there are enough blank cells to the right to hold all of the cells of data in the address block.

    This method can be tedious because you need to do it separately for each address block, but recording a macro to do it would help. Someone more expert than myself can no doubt give you a macro instructions that would loop through your file and do it all in one go.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1