UNICHAR Function in Excel: Any Unicode Symbol
UNICHAR returns a character from its Unicode number — arrows, ticks, the rupee sign — without hunting through Insert › Symbol.
Read article →Text
Excel Text functions explained with syntax, examples and common mistakes.
CHAR Function in Excel: Character From a Code (Line Breaks, Symbols)
CHAR Function in Excel: Character From a Code (Line Breaks, Symbols)
CHAR returns the character for a code number. CHAR(10) is a line break — the key to multi-line cells built by formula. CODE does…
Read article →UNICODE Function in Excel: Unicode Number of a Character
UNICODE Function in Excel: Unicode Number of a Character
UNICODE returns the code point of the first character. Unlike CODE it is correct for Hindi, emoji and symbols.
Read article →LOWER Function in Excel: Convert Text to Small Letters
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 →UPPER Function in Excel: Convert Text to Capitals
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 →REPLACE Function in Excel: Replace Characters by Position
REPLACE Function in Excel: Replace Characters by Position
TextLevel: IntermediateAvailable in: Excel 2007+REPLACE swaps characters at a given position — useful for masking.Syntax=REPLACE(old_text, start_num.
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 →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 →CODE Function in Excel: Character Code of the First Letter
CODE Function in Excel: Character Code of the First Letter
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…
Read article →TRIM Function in Excel: Remove Extra Spaces
TRIM Function in Excel: Remove Extra Spaces
TRIM removes leading and trailing spaces and reduces multiple spaces between words to one. Essential after copying data from websites and ERPs.
Read article →DOLLAR Function in Excel: Number as Currency Text
DOLLAR Function in Excel: Number as Currency Text
DOLLAR formats a number as currency text using your computer’s currency symbol. The name is historic — on an Indian-locale PC it shows ₹.
Read article →