UPPER Function in Excel: Convert Text to Capitals
UPPER makes text all capitals; LOWER makes it all small letters. Useful for codes, PAN and GSTIN that must be uppercase.
Read article →SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can…
Read article →TIMEVALUE Function in Excel: Text Time to Real Time
TIMEVALUE Function in Excel: Text Time to Real Time
TIMEVALUE turns text like "2:45 PM" into a real time you can add and subtract.
Read article →Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
VLOOKUP returns only the first match. Combine TEXTJOIN, UNIQUE and FILTER to list every matching value in one cell — plus a version for…
Read article →REPLACE Function in Excel: Replace Characters by Position
REPLACE Function in Excel: Replace Characters by Position
REPLACE swaps characters at a given position — useful for masking.
Read article →NUMBERVALUE Function in Excel: Convert Text Numbers With Any Separators
NUMBERVALUE Function in Excel: Convert Text Numbers With Any Separators
NUMBERVALUE converts text to a number using separators you specify — essential for European-style “1.234,56” exports.
Read article →DATEVALUE Function in Excel: Convert Text Dates Into Real Dates
DATEVALUE Function in Excel: Convert Text Dates Into Real Dates
DATEVALUE turns a date written as text into a real date number. It follows your Windows regional settings, which is exactly why it sometimes…
Read article →CLEAN Function in Excel: Remove Non-Printing Characters
CLEAN Function in Excel: Remove Non-Printing Characters
CLEAN removes invisible control characters (like line breaks from system exports) that break lookups and look like spaces.
Read article →SUBSTITUTE Function in Excel: Replace Specific Text
SUBSTITUTE Function in Excel: Replace Specific Text
SUBSTITUTE replaces existing text with new text — all occurrences or just the n-th one.
Read article →ACCRINT Function in Excel: Interest Earned Since Last Coupon
ACCRINT Function in Excel: Interest Earned Since Last Coupon
ACCRINT calculates interest that has built up on a bond — the amount a buyer pays the seller on top of the quoted price.
Read article →PROPER Function in Excel: Capitalise Each Word
PROPER Function in Excel: Capitalise Each Word
PROPER capitalises the first letter of each word; UPPER and LOWER change the whole text.
Read article →VALUE Function in Excel: Convert Text to a Number
VALUE Function in Excel: Convert Text to a Number
VALUE turns text that looks like a number into a real number, so SUM and lookups work.
Read article →