Hi!
I've got this Excel sheet with a bunch of First names and Lastnames.
Based on these values, I want to generate a username. But, some people have a middle name as well, perhaps even two. Is it possible to get the first character from each WORD in the firstname cell?

If some guy is named John F Kennedy, the username should be jfkennedy.

Right now, I've got this formula, but it only collect the first character from the firstname and not the first character from each word separated by a space from that cell. Meaning, the result is "jkennedy" and not "jfkennedy"

My formula right now looks like this (Removes odd characters from our language):
Please Login or Register  to view this content.
Any ideas?
Edit: Just to make it clear, the source data is only in two columns, there is no "middle name" column. The middle name is in the First name cell only separated by a space character.