Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jul 2012
    Posts
    965
    Thanks
    661
    Thanked 58 Times in 57 Posts

    Rearrange Smith, John to John Smith in Excel

    I volunteer at a local non profit organization and someone had built an Excel workbook with about 275 volunteer names such as Smith, John in one cell; for example cell A1
    --- The manager asked me to rearrange Smith, John to John Smith in its same cell
    --- I have Excel 2000
    What is the formula to do that?

    I used to work with Excel and I believe that once I have the first cell set up properly, all Iíll have to do is click in the lower right corner of the cell and drag down to input the applicable formula for each one of the subsequent cells
    --- However, how can I apply the formula to full range of cells?

  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
    You can use a formula like:
    =MID(A1,2+FIND(",",A1),LEN(A1))&" "&LEFT(A1,FIND(",",A1)-1)

    You don't have to drag, you can select the lower right cell and double-click to put the formula down the entire column of filled cells
    The copy that column and paste-special values into Column A, then you can delete the formulas.

    Steve

  3. #3
    5 Star Lounger
    Join Date
    Jul 2012
    Posts
    965
    Thanks
    661
    Thanked 58 Times in 57 Posts
    Thank you Steve. That formula works excellently

  4. #4
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post
    No code has to be inserted here.

  5. The Following User Says Thank You to bosco_yip For This Useful Post:

    r3x3 (2012-09-22)

Posting Permissions

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