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.”
•  Step 2: You need to check the box next to “Auto-hide the Taskbar” and click “OK.” This will remove the Windows 7 taskbar from your desktop.
•  Step 3: If you want to add the taskbar back, drag the cursor over the area where the Windows 7 taskbar used to be. This will display the Windows 7 taskbar.
•  Step 4: Now click “Start,” “Control Panel,” “Appearance and Personalization” and “Taskbar and Start Menu.”
•  Step 5: Here you have to uncheck the box next to “Auto-hide the Taskbar.”
•  Step 6: Click “OK.” This will add the Windows 7 taskbar back to your desktop.

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 enabled

Read More