D DarkStar Mar 2, 2008 #1 How do I replace the first name with the first initial from a list of first an d last names? e.g. John Doe with J Doe Thank you,
How do I replace the first name with the first initial from a list of first an d last names? e.g. John Doe with J Doe Thank you,
R Rick Rothstein \(MVP - VB\) Mar 3, 2008 #3 Here is another way... =SUBSTITUTE(A1,MID(A1,2,FIND(" ",A1)-2),"") Rick
R Ron Rosenfeld Mar 3, 2008 #5 How do I replace the first name with the first initial from a list of first an d last names? e.g. John Doe with J Doe Thank you, Click to expand... =REPLACE(A1,2,FIND(" ",A1)-2,"") If it is possible that either the first or last name is not properly capitalized, you could use this to also capitalize properly: =PROPER(REPLACE(A1,2,FIND(" ",A1)-2,"")) --ron
How do I replace the first name with the first initial from a list of first an d last names? e.g. John Doe with J Doe Thank you, Click to expand... =REPLACE(A1,2,FIND(" ",A1)-2,"") If it is possible that either the first or last name is not properly capitalized, you could use this to also capitalize properly: =PROPER(REPLACE(A1,2,FIND(" ",A1)-2,"")) --ron
