D
DarkStar
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,
an d last names?
e.g.
John Doe with J Doe
Thank you,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=LEFT(A1)&" "&MID(A1,FIND(" ",A1)+1,99)
R
Rick Rothstein \(MVP - VB\)
Here is another way...
=SUBSTITUTE(A1,MID(A1,2,FIND(" ",A1)-2),"")
Rick
=SUBSTITUTE(A1,MID(A1,2,FIND(" ",A1)-2),"")
Rick
R
Ragdyer
Try this:
=LEFT(A1)&MID(A1,FIND(" ",A1),50)
=LEFT(A1)&MID(A1,FIND(" ",A1),50)
R
Ron Rosenfeld
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,
=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