Sorry for clicking Send too fast. You may also need:
=LEFT(A1,1)
returns the first letter from A1.
=LOWER(A1)
converts to lowercase.
=SUBSTITUTE(A1," ","")
removes spaces.

HTH. Best wishes Harald

"Shadowofthedarkgod" skrev i
melding ...

I have this problem, see I want to create a script, I have the following
information available to me.

First name: John
MI: C
Last name: Doe

Now this is what I want; I want to convert this John C. Doe to "jcdoe".
Also
I have similar problems to with dual last names, like dela toya, I have to
convert from juan r. dela toya to jrdelatoya. How do I do that? Thanks!!