I need to create usernames from a provided list, in the following format
1. column A- First Name
2. column B - Middle Initial
3. Column C - Last Name
THe user name has to be in the following format:
here's the catch: the username cannot contain any characters outside the 26-letter alphabet set. (i.e. Pat O'Riley would be Pat.Oriley)
Also, if No middle initial exists, it must be left unentered.
i.e. John S. Andrews would be John.S.Andrews
where as Jane Smith would be Jane.Smith
(notice only 1 "." was used in the 2nd case)
I have already done this with formulas, but its 7MB large, and very inefficeint. It checks letter by letter to see what it is, and it can do so for up to 51 letters
I want to do this in a macro, but i'm not sure how........any ideas?