Hi!

Only tested with 2 word names. Will not work with 3 or more word names.

A1 = John Michael or John
A2 = C
A3 = Dela Toya or Doe


=LEFT(A1,1)&IF(ISERROR(FIND(" ",A1)),"",MID(A1,FIND("
",A1)+1,1))&A2&SUBSTITUTE(A3," ","")

Returns:
JMCDelaToya

OR:

JCDoe

Biff


"Shadowofthedarkgod" wrote in
message ...

I have the following input:

First name: John Michael or John
MI: C
Last name: Dela Toya or Doe

Now what I need is to convert John Michael C Dela Toya to jmcdelatoya, or
John C Doe to jcdoe. I'm having trouble in making excel count the number
of
words in a name, since if my input has 3 first names, it has to have 3
initials,like this: Mary Jane Carmen D. Roberts to mjcdroberts. Can anyone
help me pls? Thanks