View Single Post
  #1   Report Post  
Shadowofthedarkgod
 
Posts: n/a
Default How do I get the first letter of a word in excel


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!!