Hi
Using
Public Function UserName()
UserName = Environ$("UserName")
End Function
then
Range("C2").Select
ActiveCell.FormulaR1C1 = "=UserName()"
Is it possible to display the name with Capital on the first name Capital on the surname, with a space in the middle?
thanks
How is the username currently displayed - what delimits the first / last names?
If, for example, the name is in the format john.smith then you could use:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Please post code in [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags.
I don't know how your User name looks like, this is an assumption.
Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
Thanks
sorry it displays it
tomsmith
davidjones
rachelsmith
johnsmith
etc etc
the above doesnt appear to work.
thanks for the reply
Ok, obviously it wouldn't work.
How are you going to differentiate the first name and surname?
No macro would be smart enough to do that (I think), unless you have a predefined list of names.
Okay, so how will any formula or code identify where the first name ends and the last name begins?Originally Posted by papasmurfuo9
Hi,
with no separator, can't split firstname and name ‼
You have to build a translate table …
Cheers
wasnt sure how environ username works, or how it pulled it through
but thanks for the confirmation
application.username may (or may not) be worth considering too, depending on your system policies on user naming.
Cheers
i will use the following
then build a table with all the users with a lookup, using iferror to display the username with no space/capitals if they aint in the tablePlease Login or Register to view this content.
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks