formula '=USERNAME()' doesn't work

Question

i am trying to use USERNAME function to automatically write name of the user in excel sheet into a cell. It keeps showing me #name? error.

I have tried to enable iteration calculation or use just =user() formula but it doesnt work either

I am using microsoft 365 for businesses

Thank you

Answer 1

There is no function USERNAME, nor is there a USER.

Try this - for desktop versions of 365.

=LET(fullpath, INFO("DIRECTORY"),path, SUBSTITUTE(fullpath, "C:\Users", ""),LEFT(path, FIND("", path) - 1))

You can also use VBA, but that also requires desktop Excel.