text to columns

Discussion in 'Computers' started by ShiftZZ, Nov 16, 2009.

  1. ShiftZZ

    ShiftZZ Funster Life Member

    Joined:
    Feb 19, 2008
    Messages:
    19,821
    Likes Received:
    35,887
    Location:
    Leicestershire
    To funsters.
    I have a large spreadsheet of names and I am trying to split them up into different fields.,

    The 1st column contains the following data
    James John Hughes
    Rudolph Smith
    Betty Davies
    Norbert Jones-Hughes
    Cassandra Betty Philips Jane Wilson

    This is what I want to achieve...
    James John _________________________________________Hughes
    Rudolph ____________________________________________Smith
    Betty ______________________________________________Davies
    Norbert ____________________________________________Jones-Hughes
    Cassandra Betty Philips Jane ____________________________Wilson



    I can’t see a way of using text to columns....
    Any suggestions?

    Ta

    ShiftZZ
     
  2. Wildman

    Wildman Read Only Funster

    Joined:
    May 30, 2008
    Messages:
    15,458
    Likes Received:
    8,598
    Location:
    Ilfracombe, Devon
    import data to a spreadsheet, make a text file and separate text with a comma, import domma delimited file, job done.
    i.e.

    john francis, jones
    fred, bloggs
    might need commas after surname as well. Try it and see.
     
  3. pappajohn

    pappajohn Funster Life Member

    Joined:
    Aug 26, 2007
    Messages:
    29,466
    Likes Received:
    16,913
    Location:
    YO11 2BD
    not quite what he's after roger...

    This is what I want to achieve...
    James John _________________________________________Hughes
    Rudolph ____________________________________________Smith
    Betty ______________________________________________Davi es
    Norbert ____________________________________________Jones-Hughes
    Cassandra Betty Philips Jane ____________________________Wilson
     
  4. ShiftZZ

    ShiftZZ Funster Life Member

    Joined:
    Feb 19, 2008
    Messages:
    19,821
    Likes Received:
    35,887
    Location:
    Leicestershire
    Thanks guys.

    Its the two 1st names that causing the problem, it would be easy, if I could split it from the right to the 1st space.

    ShiftZZ
     
  5. madbluemad

    madbluemad

    Joined:
    Jan 26, 2008
    Messages:
    3,341
    Likes Received:
    243
    Location:
    spain
    I assume its an Excel Spreadsheet that your working on.

    Open a new page, In the first cell (A1) type whatever name you want in there. Move to the right (second column) and tpe whatever name you want in there. So on and so on.

    Move down column A to the second row and do the same again.


    Is this the sought of thing you want?

    Jim
    :Smile:
     
Loading...

Share This Page