Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2004
    Location
    Withyham, Sussex, England
    Posts
    121
    Thanks
    2
    Thanked 1 Time in 1 Post

    Seperate fields (excel 2002 sp3)

    Hi, I have performed a cursory search but don't really know what to search on, so please forgive me if this is a common question. I have a text file exported from an ancient access database that has so many errors I can no longer import it into a DB. I have managed to get excel to open it and would like to know if there is a way in excel to separate some of the data from "firstname" (Row f if this helps) where they have put both the first name and middle name in the same field (27,000 records) the only thing separating them is a space. I am using excel 2002 sp3 and xpsp2 . I really hope that I do not have to do this manually, so if anyone has a solution I shall be very grateful. Cheers gws

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Seperate fields (excel 2002 sp3)

    You can use
    data - text to columns
    delimited - space

    And it will separate into columns at the space

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Aug 2004
    Location
    Withyham, Sussex, England
    Posts
    121
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Seperate fields (excel 2002 sp3)

    Thank you so much for that, I just tried it and it did indeed separate the data but columns h to k disappeared? I have undone the action and the columns have returned so I shall try again and let you know how I get on. Thanks gws

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

    Re: Seperate fields (excel 2002 sp3)

    If necessary, insert some empty columns to the right of the column you want to split.

  5. #5
    2 Star Lounger
    Join Date
    Aug 2004
    Location
    Withyham, Sussex, England
    Posts
    121
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Seperate fields (excel 2002 sp3)

    Thank you both for your help, inserting blank columns and removing some weird code from a few of the cells and I now have separate first and middle names. Cheers gws

Posting Permissions

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