Results 1 to 6 of 6

Thread: Formula for format change?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2011
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula for format change?

    Hi,

    I am running Excel 2007 in Windows XP.

    How do I change a cell from "Smith,John" to "John Smith"?

    Is there a formula I can use? What's the quickest way?


    Thanks for the help!

  2. #2
    Board Regular Weaver's Avatar
    Join Date
    Sep 2008
    Posts
    5,196
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for format change?

    Assuming your string is in A2, you could use:

    =MID(A2,SEARCH(",",A2)+1,255)&" "&LEFT(A2,SEARCH(",",A2)-1)
    If the above suggestion contains vb code and you're not sure about using macros,check the following links (which in no way should be interpreted as being specific to your individual query):

    http://www.mrexcel.com/articles/past...o-into-vbe.php

    You can find help with array formulas here:

    http://www.cpearson.com/excel/arrayformulas.aspx

    If you really want to learn Excel, don't always accept the first solution.

  3. #3
    New Member
    Join Date
    Jul 2011
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for format change?

    Thank you, sir. That worked perfectly.

  4. #4
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,623
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formula for format change?

    Quote Originally Posted by dbpowell89 View Post
    Hi,

    I am running Excel 2007 in Windows XP.

    How do I change a cell from "Smith,John" to "John Smith"?

    Is there a formula I can use? What's the quickest way?


    Thanks for the help!
    Here's another one...

    =MID(A2&" "&A2,FIND(",",A2)+1,LEN(A2))
    .
    Biff
    Microsoft MVP - Excel

    Don't be afraid to use volatile functions or array formulas
    Tell us what version of Excel you're using
    KISS - Keep It Simple Stupid

  5. #5
    New Member
    Join Date
    Jul 2011
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for format change?

    Thanks guys, appreciate the help.

  6. #6
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,623
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formula for format change?

    Quote Originally Posted by dbpowell89 View Post
    Thanks guys, appreciate the help.
    You're welcome!
    .
    Biff
    Microsoft MVP - Excel

    Don't be afraid to use volatile functions or array formulas
    Tell us what version of Excel you're using
    KISS - Keep It Simple Stupid

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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