Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Durham, North Carolina, USA
    Posts
    140
    Thanks
    5
    Thanked 1 Time in 1 Post

    Help with formula, please (Excel XP)

    Hi everyone,

    I'm not much of an Excel geek ; this formula I need to write is bugging me.

    I have a long list of names I need changed. The names are in this format: lastname-initial(s)

    and I need them initial(s) lastname.

    For example, Anderson-CG would become CG Anderson and Brady-E would become E Brady.

    Can someone help me out? I would greatly appreciate it!

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with formula, please (Excel XP)

    <P ID="edit" class=small>(Edited by wdwells on 23-Jan-09 14:56. Formula corrected to return Initials first, not last.)</P>Assuming the current list of names is in column A; paste the following formula in row 1 of your results column; and fill down as far as necessary.
    <center>=RIGHT(A1,LEN(A1)-FIND("-",A1,1))&" "&LEFT(A1,FIND("-",A1,1)-1)</center>
    Regards
    Don

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with formula, please (Excel XP)

    Another method can also be used:

    Select the column (say column A) with the names and from the Data Menu choose Text To Columns.
    Select the "-" as the delimiter to split the names into the adjacent column (say column
    Now that the names are split into two columns, in column C type: =B1 & " " & A1 and fill down to create the concatenated version you need.
    Regards,
    Rudi

Posting Permissions

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