+ Reply to Thread
Results 1 to 11 of 11

converting names format

  1. #1
    Registered User
    Join Date
    11-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    converting names format

    I have a data base of people that have the last name first, then the first name: Villamarin,Sara

    I need to be able to quickly seperate the names into two seperate columns.
    Column 1: Sara
    Column 2: Villamarin

    How do I do that?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: converting names format

    try Text2Columns
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: converting names format

    hi,
    this can be done by using left or right or LEN With help of Find function , before it is necessary to know the data discipline in u r workbook , so provide a sample workbook with out confidential data.

    Punnam

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: converting names format

    No formula needed. If the format is as posted, use TextToColumns with , as the delimiter

  5. #5
    Registered User
    Join Date
    11-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: converting names format

    I don't understand. What exactly do I do?

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: converting names format

    Just follow these directions:
    Click on Column where the names are listed, Go to Text to Columns located on the Data tab. select Delimited and click Next, select comma and click Finish
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  7. #7
    Registered User
    Join Date
    11-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: converting names format

    thanks that worked.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: converting names format

    Thanks for the assist, AlKey

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  9. #9
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: converting names format

    You're welcome and thank you for the feedback!

  10. #10
    Registered User
    Join Date
    11-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: converting names format

    Thanks that worked great. Now that I have seperated the parts of the name, I moved the last name after the first name. Now I need to combine them into one column. How do I do that?

  11. #11
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: converting names format

    To combine then back again in reverse use this simple formula

    =B1&" "&A1

    Row\Col
    A
    B
    C
    1
    Villamarin Sara Sara Villamarin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 04-01-2014, 09:37 AM
  2. Converting DATE format to GENERAL format?
    By timtim in forum Excel General
    Replies: 9
    Last Post: 08-19-2011, 02:38 AM
  3. Converting number format to time format
    By mbarr in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-28-2011, 09:19 AM
  4. Converting Dates to Actual Day Names
    By scarames in forum Access Tables & Databases
    Replies: 6
    Last Post: 05-04-2010, 05:11 PM
  5. converting date format to text format
    By membership in forum Excel General
    Replies: 4
    Last Post: 03-17-2010, 03:24 AM

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