M Mich Jul 15, 2003 #1 I have a cell that has the last name, first name. I would like to make it first name last name. Any suggestions? Thanks
I have a cell that has the last name, first name. I would like to make it first name last name. Any suggestions? Thanks
D dvt Jul 15, 2003 #2 Mich said: I have a cell that has the last name, first name. I would like to make it first name last name. Any suggestions? Thanks Click to expand... If "last name, first name" is in A7, put this formula in another cell: =MID(A7,FIND(",",A7),256)&" "&(LEFT(A7,FIND(",",A7)-1)) Assumptions: -name is <= 256 characters long -the comma is only used to separate the two names; it is never part of the name itself Dave dvt at psu dot edu
Mich said: I have a cell that has the last name, first name. I would like to make it first name last name. Any suggestions? Thanks Click to expand... If "last name, first name" is in A7, put this formula in another cell: =MID(A7,FIND(",",A7),256)&" "&(LEFT(A7,FIND(",",A7)-1)) Assumptions: -name is <= 256 characters long -the comma is only used to separate the two names; it is never part of the name itself Dave dvt at psu dot edu
D dvt Jul 15, 2003 #3 Mich said: I have a cell that has the last name, first name. I would like to make it first name last name. Any suggestions? Thanks Click to expand... Oops - I forgot the +2 in the original formula. Same restrictions apply. =MID(A7,FIND(",",A7)+2,256)&" "&(LEFT(A7,FIND(",",A7)-1)) Dave dvt at psu dot edu
Mich said: I have a cell that has the last name, first name. I would like to make it first name last name. Any suggestions? Thanks Click to expand... Oops - I forgot the +2 in the original formula. Same restrictions apply. =MID(A7,FIND(",",A7)+2,256)&" "&(LEFT(A7,FIND(",",A7)-1)) Dave dvt at psu dot edu
M Mike Jul 15, 2003 #4 As long as there is a space after the comma, this will do. =RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)- 1)
As long as there is a space after the comma, this will do. =RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)- 1)
