Prashant Gupta

Make Google Sheets enter "London" in column D every time I enter "Diana" in Column C

Extract the last word from a cell in Excel

Extract first three digits of a number in Excel

Extract cell values if first few characters match the given text in a range of cells in Excel

Rotate text in Excel

Remove negative sign in Excel

Google Sheets: filter out values present in one column, but missing in another column

Convert date given in dd-mm-yyyy format to yyyy-mm-dd format in Excel using formula

Highlight an specific text in entire column in Excel

Shortcut key to add cell border in Excel

Uninstall Chrome extensions

Find row of the cell with max value in a column in Excel

Convert negative values to zero using Custom formatting and Max function in Excel

Convert a range into Proper case in Excel using VBA

Convert HEX color codes to RGB color codes in Excel

Highlight the cell in a row based on current date in Excel

Sum only the numeric values from a column in Excel

Insert check mark (tick symbol) in Excel

Add Kg as suffix to values in Excel using custom formatting

Change color of cell if two cells are not equal in Excel

Add comma after first word in each cell in Excel

Count duplicates in Excel

Find and replace values greater than/less than a specific value with VBA code in Excel

Find specific text in a range of cells in Excel

Clear cell contents based on color in Excel

Convert ODD numbers into EVEN numbers and vice versa in Excel

Count duplicate values in Google Sheets

Convert UTC date/time to local time in Excel

Filter by cell font color in Excel using VBA

Insert Breakpoints in a macro in Excel VBA

Split numbers into columns in Excel

Excel VBA: Automatically insert Option Explicit in a new module

Working with ActiveX checkbox in Excel VBA: Example 4

How to enable/disable cookies in Google Chrome

Auto-fill text based on text in another cell in Excel or Data linking in Excel

Extract all 7 digit numbers from a list in Excel

Copy text from PDF

Convert UTC time to PDT (Pacific Daylight Time) time in Excel

Show UserForm in Excel VBA using Command Button

Replace

Extract time from date & time in Excel

Deselect specific cells, rows or columns in Excel

Convert date/time format cell to date only in Excel

Highlight column and row of active cell from selected range in Excel without VBA

Automatically extract a part of string between parentheses in Excel

Few examples on column validation for tables in MS Access

Find average of only last 7 values in a rightward moving row in Excel

Excel: Add specific text to the beginning/end of all cells

Split the Date in Month, Day, Year in Excel using VBA

Prevent duplicate entry in Excel

Get computer's system information with a shortcut key