How to find long videos only on YouTube?

query to find long videos on YouTube

Simple search query to find only long videos (more than 20 minutes) in YouTube search results. Add keyword long to the search query. Example: prank, long If you want only short videos (less than 4 minutes) in search results , then use keyword Short Example: short film, short

How to find 4K or HD videos only on YouTube?

search query to get 4K videos only on YouTube

If you want to see HD (High-definition) videos only in YouTube search results, then add keyword hd to the search query. Example: avatar, hd To get only 4K Ultra High Definition videos in search results, add 4K to the search query. Example: movie, 4K

Backup your WhatsApp data to Google Drive

You can backup your WhatsApp data (messages, photos, videos) to Google drive automatically. Follow below steps. On Android phone Open WhatsApp Goto Chats screen Click on Menu (right-upper corner, three dots in vertical) Goto Settings Click on Chats Click on Chat backup In Google Drive Settings, select your google account, how frequently you want to […]

How to install WhatsApp on Windows computer?

You can install WhatsApp on your computer if your PC operating system is Windows 8+ (or newer). Below are the simple steps. Goto https://www.whatsapp.com/download/ Click the WhatsApp download button for Windows PC. A file named “WhatsAppSetup.exe” is downloaded. Click on above downloaded exe file to install WhatsApp on your computer or PC or laptop Once […]

8 steps to install WhatsApp on Android Tablet without SIM card

Steps to install WhatsApp on Android tablet without SIM card. Goto Settings-> Security Select “Unknown sources” to enable your tablet to install apps from unknown sources Copy below secure link from official website of whatsapp and paste it into your browser such as Google chrome or any other browser    http://www.whatsapp.com/android/ Above link opens latest […]

Combine multiple columns data to single column [Excel VBA]

combine-multiple-columns-data-to-single-column-excel-vba

If you want to combine multiple columns data to a single column using excel VBA, then use below code. Below macro combines data of 10 columns and displays it in first column. Change numOfColumns variable value as per your requirement.

Remove blank rows inside cell [excel VBA]

remove-blank-rows-inside-cell-excel-vba

We can create new line/row inside a cell by pressing ALT+ENTER in MS Excel. If you come across a situation where you want to remove blank rows/lines inside the cell, then you can’t remove them using trim method. Below code helps you to remove them automatically using VBA code.

In the above code Chr(10) […]

[Excel VBA code] Convert a string to Uppercase letters

excel-vba-convert-string-to-uppercase-output

Excel VBA code to convert a string to uppercase letters. It converts all lowercase letters to uppercase.

Output:

VBA code to capitalize each word of a string [Excel]

capitalize-each-word-string-VBA-excel

Below is the Excel VBA code to capitalize each word of a string.

Output:

Page 3 of 1312345...10...Last »