+ Reply to Thread
Results 1 to 5 of 5

First name, Last name in seperate columns

  1. #1
    Registered User
    Join Date
    05-03-2006
    Posts
    5

    First name, Last name in seperate columns

    Hello,
    I have a very large spreadsheet with customer information...Company, Name, Address, City, etc etc...The problem is that Name is first name and last name in one column...I would like to have first name in one column and last name in another. Is there any way to do this without copying and pasting 25,000 names?
    Any help would save me days of work
    Thanks
    John

  2. #2
    Bob Phillips
    Guest

    Re: First name, Last name in seperate columns

    Insert a column at B.
    Select column A.
    Data>Text To Columns and use a delimiter of space.

    --
    HTH

    Bob Phillips

    (remove xxx from email address if mailing direct)

    "Capt_Trips" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hello,
    > I have a very large spreadsheet with customer information...Company,
    > Name, Address, City, etc etc...The problem is that Name is first name
    > and last name in one column...I would like to have first name in one
    > column and last name in another. Is there any way to do this without
    > copying and pasting 25,000 names?
    > Any help would save me days of work
    > Thanks
    > John
    >
    >
    > --
    > Capt_Trips
    > ------------------------------------------------------------------------
    > Capt_Trips's Profile:

    http://www.excelforum.com/member.php...o&userid=34080
    > View this thread: http://www.excelforum.com/showthread...hreadid=538429
    >




  3. #3
    Don Guillett
    Guest

    Re: First name, Last name in seperate columns

    Have you tried?
    Data>text to columns

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "Capt_Trips" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hello,
    > I have a very large spreadsheet with customer information...Company,
    > Name, Address, City, etc etc...The problem is that Name is first name
    > and last name in one column...I would like to have first name in one
    > column and last name in another. Is there any way to do this without
    > copying and pasting 25,000 names?
    > Any help would save me days of work
    > Thanks
    > John
    >
    >
    > --
    > Capt_Trips
    > ------------------------------------------------------------------------
    > Capt_Trips's Profile:
    > http://www.excelforum.com/member.php...o&userid=34080
    > View this thread: http://www.excelforum.com/showthread...hreadid=538429
    >




  4. #4
    Bob Phillips
    Guest

    Re: First name, Last name in seperate columns

    Insert a column at B.
    Select column A.
    Data>Text To Columns and use a delimiter of space.

    --
    HTH

    Bob Phillips

    (remove xxx from email address if mailing direct)

    "Capt_Trips" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hello,
    > I have a very large spreadsheet with customer information...Company,
    > Name, Address, City, etc etc...The problem is that Name is first name
    > and last name in one column...I would like to have first name in one
    > column and last name in another. Is there any way to do this without
    > copying and pasting 25,000 names?
    > Any help would save me days of work
    > Thanks
    > John
    >
    >
    > --
    > Capt_Trips
    > ------------------------------------------------------------------------
    > Capt_Trips's Profile:

    http://www.excelforum.com/member.php...o&userid=34080
    > View this thread: http://www.excelforum.com/showthread...hreadid=538429
    >




  5. #5
    Don Guillett
    Guest

    Re: First name, Last name in seperate columns

    Have you tried?
    Data>text to columns

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "Capt_Trips" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hello,
    > I have a very large spreadsheet with customer information...Company,
    > Name, Address, City, etc etc...The problem is that Name is first name
    > and last name in one column...I would like to have first name in one
    > column and last name in another. Is there any way to do this without
    > copying and pasting 25,000 names?
    > Any help would save me days of work
    > Thanks
    > John
    >
    >
    > --
    > Capt_Trips
    > ------------------------------------------------------------------------
    > Capt_Trips's Profile:
    > http://www.excelforum.com/member.php...o&userid=34080
    > View this thread: http://www.excelforum.com/showthread...hreadid=538429
    >




+ 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