From: Myk on 29 Apr 2010 15:48 I currently have a list of names all in one column of cells that are formatted last name, first name (with a space after the comma). I need to change to first name last name. There are several names with no space after the comma in case that matters. Is there an easy way to make this change? Thanks, MYK From: Luke M on 29 Apr 2010 15:54 =TRIM(MID(A2,FIND(",",A2)+1,999))&" "&LEFT(A2,FIND(",",A2)-1) This will handle both cases of having a space, or no space -- Best Regards, Luke M "Myk" wrote in message news:FD6400CB-ADE8-45B7-A452-8762DF07CA99(a)microsoft.com...>I currently have a list of names all in one column of cells that are > formatted last name, first name (with a space after the comma). I need to > change to first name last name. There are several names with no space > after > the comma in case that matters. > > Is there an easy way to make this change? > > Thanks, > MYK From: Jim Thomlinson on 29 Apr 2010 16:09 Try a formula like this... =TRIM(MID(A1, FIND(",", A1)+1, 256)) & " " & LEFT(A1, FIND(",", A1)-1) -- HTH... Jim Thomlinson "Myk" wrote: > I currently have a list of names all in one column of cells that are > formatted last name, first name (with a space after the comma). I need to > change to first name last name. There are several names with no space after > the comma in case that matters. > > Is there an easy way to make this change? > > Thanks, > MYK  |  Pages: 1 Prev: Excel macro deploymentNext: Highlight the cell/row if particular name comes..