Link to home
Start Free TrialLog in
Avatar of contrain
contrainFlag for United States of America

asked on

Need macro to split first and last name into initial

In the attached file, in column A I have first and last names. I need to create, in column B, a login name for each person that is their first initial and last name. Is there a macro or something that will do this? I can get rid of the middle initials if necessary. Thanks.
FirstInitialLastName.xls
SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of contrain

ASKER

Both experts gave me the answer I wanted. Each solution worked on the sheet I attached, and on another similar sheet too. I'm more comfortable with the fill handle version (spatewar's) than the macro, but each was perfect.
I'm glad I was able to help.

Marty - MVP 2009 to 2012