Hopefully I'm not a moocher, but for my second request this week, similar to my previous thread (https://www.excelforum.com/excel-pro...ml#post5194089), I use a software package that spits out some data that I need in a different format. Rick Rothstein kindly provided a small macro to reformat some text strings into a proper, usable time format. I have been poking at that code trying to understand it and repurpose it into this problem, but I'm stuck because ... well I believe his code changes some characters around then defines what format the numbers should be in. This works perfectly for numbers that have defined formats, but not text strings like what I'm working with.
Basically, I am given employee names in a format "nnnn - Lastname, Firstname" (with nnnn being a badge #), but I need it in FirstInitial. Lastname format. I have been using a formula to do this:
This formula works for hypenated last names as well as multiple names as one would find in a Hispanic country (Jorge Francisco Lopez Gonzales, for example, where there is no clear middle name but multiple words in a name, shown as "Firstinitial. Name1 Name2 Name3".Please Login or Register to view this content.
Thanks in advance for any advice.
Bookmarks