LOWER Function in Excel: Convert Text to Small Letters
LOWER converts all letters to lowercase — handy when comparing emails or usernames typed inconsistently.
Read article →LOWER converts all letters to lowercase — handy when comparing emails or usernames typed inconsistently.
Read article →UPPER makes text all capitals; LOWER makes it all small letters. Useful for codes, PAN and GSTIN that must be uppercase.
Read article →Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can run in a free online playground.
Read article →VLOOKUP returns only the first match. Combine TEXTJOIN, UNIQUE and FILTER to list every matching value in one cell — plus a version for older Excel.
Read article →TextLevel: IntermediateAvailable in: Excel 2007+REPLACE swaps characters at a given position — useful for masking.Syntax=REPLACE(old_text, start_num.
Read article →PRICE returns a bond’s price per 100 face value. When market yield rises above the coupon, price falls below 100 — the see-saw every debt-fund investor feels.
Read article →CLEAN removes invisible control characters (like line breaks from system exports) that break lookups and look like spaces.
Read article →Use approximate-match lookups for slabs and bands: how TRUE/-1 matching works, building a bands table, commission and grade examples, progressive tax slabs with SUMPRODUCT, and common traps.
Read article →SUBSTITUTE replaces existing text with new text — all occurrences or just the n-th one.
Read article →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 capitalises the first letter of each word; UPPER and LOWER change the whole text.
Read article →CODE returns the number of the first character. It is the detective tool for “invisible” characters that break lookups: a non-breaking space shows up as 160, not 32.
Read article →