Please refer the attached sample excel sheet. I have Domain login username in Column "A". I would like to run a command in Column "B". Which takes values from Column "A" as parameter. Basically it runs Dsquery user command to get displayname of specific user.
It gives out put like below
I would like to have Only the "Lastname1, Firstname1" to be updated as output in column “C”.
Currently I am keeping Column “B” in batch file and pipe the result in to a text file and the removing “display” and “dsget succeeded”. Then pasting the results in to Column “C”. This is time consuming and might result in error if other users do it. So I want everything to be done by excel.
Let me know how the command in column “B” can be executed within excel and the output comes in Column “C” as a display name of the user only.