nth occurance of a character in Excel

To find the last occurance of "," (comma) in a string in excel =RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,",","|",LEN(A1)-LEN(SUBSTITUTE(A1,",",""))))) This will find the last occurance of the string after the last "," (comma)...

Read More

Windows 7: How to Add & Remove the Taskbar

Do you want to remove the Windows 7 taskbar from the desktop? Since the Windows 7 taskbar takes up space on the desktop, many prefer to remove the taskbar. Like other Windows operating systems, Windows 7 taskbar also includes the Start menu, shortcuts for open documents as well as programs, and notifications. After removing, if you want you can also easily add the taskbar back. Let’s take a look at the following steps. •  Step 1: Click “Start,” then “Control Panel,” “Appearance and Personalization” and “Taskbar and Start Menu.” • ...

Read More

Windows 7 GodMode

Windows 7 has a useful but hidden GodMode that displays all the operating system's administration tools and control options on a single screen, giving you instant access to settings that can customise and enhance your PC. TO Activate GodMode Go to Start, Computer and Select C: Drive Right Click and Create New Folder Highlight and Rename the Folder by pressing F2 and rename it to; GodMode.{ED7BA470-8E54-465E-825C-99712043E01C} and press enter The Folder Changes to Control Panel Icon and GodMode Options will be enabl...

Read More