FORMULAE - REPLACE
 

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,

FORMULAE - REPLACE
 

=LEFT(A1)&" "&MID(A1,FIND(" ",A1)+1,99)


"DarkStar" wrote:

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,

FORMULAE - REPLACE
 

Here is another way...

=SUBSTITUTE(A1,MID(A1,2,FIND(" ",A1)-2),"")

Rick


"DarkStar" wrote in message
...
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,

FORMULAE - REPLACE
 

Try this:

=LEFT(A1)&MID(A1,FIND(" ",A1),50)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"DarkStar" wrote in message
...
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,

FORMULAE - REPLACE
 

On Sun, 2 Mar 2008 14:34:01 -0800, DarkStar
wrote:

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