Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2003
    Location
    Daytona Beach, Florida, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Last name function

    Hi guys! Anybody have a good suggestion on how to split out first and last names from a "full name" field in Excel? I've searched the MS Office Update site, but no luck. Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last name function

    If all the full names have the same number of names (first, middle, last) in them you can use the Text to Columns Wizard with space as the delimiter.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Last name function

    You might find some help at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=29612&page=&v iew=&sb=&vc=1#Post29612>This thread</A>, where a similar problem was discussed.

    Andrew C

Posting Permissions

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