FIXED Function in Excel: Round and Format as Text
FIXED rounds a number and returns it as text with or without thousands separators — good for sentences built from numbers.
Read article →Text
Excel Text functions explained with syntax, examples and common mistakes.
REPT Function in Excel: Repeat Text (In-Cell Bar Charts)
REPT Function in Excel: Repeat Text (In-Cell Bar Charts)
REPT repeats text a number of times — best known for quick bar charts inside cells.
Read article →TEXT Function in Excel: Format Numbers and Dates as Text
TEXT Function in Excel: Format Numbers and Dates as Text
TEXT converts a number or date into text using a format code — needed when you join values into labels.
Read article →CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT Function in Excel: Join Text From Cells and Ranges
CONCAT joins text from several cells or whole ranges. It replaces the older CONCATENATE. The & operator does the same for a few cells.
Read article →FINDB Function in Excel: Find Position in Bytes
FINDB Function in Excel: Find Position in Bytes
TextLevel: ExpertAvailable in: Excel 2007+FINDB is the byte-based version of FIND.Syntax=FINDB("b",text)ArgumentWhat it meanstextText to work.
Read article →LEFTB Function in Excel: Leftmost Bytes
LEFTB Function in Excel: Leftmost Bytes
LEFTB returns the first characters based on bytes. In English (single-byte) setups it behaves exactly like LEFT; it differs only when a double-byte language…
Read article →RIGHTB Function in Excel: Rightmost Bytes
RIGHTB Function in Excel: Rightmost Bytes
RIGHTB is the byte-based version of RIGHT; identical to RIGHT in English setups.
Read article →FIND Function in Excel: Position of Text (Case-Sensitive)
FIND Function in Excel: Position of Text (Case-Sensitive)
FIND returns where one text starts inside another. It is case-sensitive and does not allow wildcards — use SEARCH for that.
Read article →MID Function in Excel: Extract Text From the Middle
MID Function in Excel: Extract Text From the Middle
MID returns characters from the middle of a text, starting at a position you choose.
Read article →RIGHT Function in Excel: Take Characters From the End of Text
RIGHT Function in Excel: Take Characters From the End of Text
TextLevel: BeginnerAvailable in: Excel 2007+RIGHT returns the last characters of a text value.Syntax=RIGHT(text, [num_chars])ArgumentWhat it meanstextThe.
Read article →LEN Function in Excel: Count Characters in Text
LEN Function in Excel: Count Characters in Text
TextLevel: BeginnerAvailable in: Excel 2007+LEN returns the number of characters, including spaces.Syntax=LEN(text)ArgumentWhat it meanstextText or a.
Read article →LEFT Function in Excel: Take Characters From the Start of Text
LEFT Function in Excel: Take Characters From the Start of Text
TextLevel: BeginnerAvailable in: Excel 2007+LEFT returns the first characters of a text. RIGHT takes them from the end.Syntax=LEFT(text.
Read article →