Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need info seperated.... (2003)

    I have a spreadsheet with two colums. One is the first name and last name, the other is an address.
    My problem is I need it redone with the following columns: First Name, Last Name, Address, City, Zip, State

    I'm running short on time and need to get this done. Is there anyone I can pay via paypal to do this for me? (or send me a macro, etc that can do it)

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Need info seperated.... (2003)

    Have you tried Data | Text to Columns? (First make a backup copy of the data.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need info seperated.... (2003)

    1- Insert as many empty columns to the right of the name column as will be needed to hold the most names in the names column (one empty column if only two names for each person).

    2- Select the name column.

    3- Select "Text to columns" from the Data menu.

    4- Select Delimited in the first dialog box and click next.

    5- Select the delimiter (space, or comma) that separated the first and last name.

    6- Click Finish.

    That should separate the names into columns. Repeat the process for the addresses.
    Legare Coleman

Posting Permissions

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