Wednesday, 12 October 2016

re-Check the password entered

If you want to see what is the password that was entered in browser, here are simple steps

 

a)      Right click on the password box and select Inspect element

b)     You will see a text like this

 

 

c)      Change type=”password” to type=”text”

 

 

Magic , you have the password typed on the screen

 

Tuesday, 4 October 2016

Get Sheet Name or File Name or File Path

If you want to get some data use the following

 

=CELL("filename")

 

Then you can use ‘find’ function to trim and get what ever informaiton you want to extract