HEX2DEC Function in Excel: Hexadecimal to Decimal
HEX2DEC reads hex text — colour codes, error codes from logs — as a number.
Read article →DECIMAL Function in Excel: Any Base Back to a Number
BASE Function in Excel: Number in Any Base
BASE Function in Excel: Number in Any Base
BASE converts to any base from 2 to 36 and handles much bigger numbers than DEC2BIN.
Read article →ARABIC Function in Excel: Roman Numerals to Numbers
ARABIC Function in Excel: Roman Numerals to Numbers
ARABIC reads Roman numerals so you can sort “Part IX” correctly after “Part VIII”.
Read article →UNICHAR Function in Excel: Any Unicode Symbol
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 →ROMAN Function in Excel: Numbers to Roman Numerals
ROMAN Function in Excel: Numbers to Roman Numerals
ROMAN turns 1–3999 into Roman numerals — chapter numbers, annual-report years.
Read article →DEGREES Function in Excel: Radians to Degrees
DEGREES Function in Excel: Radians to Degrees
DEGREES converts radians back to degrees.
Read article →XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
A practical comparison of VLOOKUP, XLOOKUP and INDEX-MATCH in Excel — when each one works, when it breaks, and which to use in 2025.
Read article →RADIANS Function in Excel: Degrees to Radians
RADIANS Function in Excel: Degrees to Radians
RADIANS converts degrees, because SIN, COS and TAN in Excel expect radians.
Read article →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 →