Parse first name & surname from Windows logon name (Environ("UserName")

[mc84excel]

I was wondering if it would be possible to parse out an individuals first name & surname from their Windows logon name.

Obtaining the Windows logon name is easily done (

Please Login or Register  to view this content.

) so the only real difficulty is:

1. Correctly parse names from as many variations of a user name as possible (i.e. names separated with a full stop, names separated with an underscore etcetcera) and
2. Ignore most standard non-individual names (e.g. Administrator, Admin, Accounts, Sales etcetcera)

A quick google search throws up many results on parsing names from cells but these don't have a good success rate on actual user name formats. Below is what I have so far.

Please Login or Register  to view this content.

[AndyLitch]

I think you've set yourself a task there..

Part of the solution may be to count the number of words in the name as a first step... You could modify the function to include seperators..

Please Login or Register  to view this content.

[mc84excel]

I think you've set yourself a task there..

True. I enjoy the challenge though.

Part of the solution may be to count the number of words in the name as a first step... You could modify the function to include seperators..

Thank you for the suggestion. I'm looking into it now. (I'm trying to think of a solution to handle when the first and last name don't have a separator. e.g. JohnSmith )

[mc84excel]

I am now up to this (see code below). It's not perfect. If you try it and your user name is not parsed by the function, I would be interested in knowing what it is so I can tweak it further.

Please Login or Register  to view this content.

[JosephP]

if the users are on an active directory domain you could just query the domain controller for the user name

[mc84excel]

if the users are on an active directory domain you could just query the domain controller for the user name

Appreciate the suggestion. However I want this function as versatile as possible - work on non-networked PCs for e.g.