Lapas

piektdiena, 2015. gada 18. septembris

Excel revers find()

B1 - cell with string
~ - replace tilde(~) with other symbol if your string contains it.

=IF(ISERROR(FIND("\",B1)),B1,RIGHT(B1,LEN(B1)-FIND("~",SUBSTITUTE(B1,"\","~",LEN(B1)-LEN(SUBSTITUTE(B1,"\",""))))))

otrdiena, 2015. gada 15. septembris

Windows 7/8 enable NumLock on startup

Press Win + R and type in Regedit
Navigate to registry key HKEY_USERS\Default\Control Panel\Keyboard 
Right click on the “InitialKeyboardIndicators”, select Modify and change Value data to 2.