CONCATENATE Function in Excel: The Old Way to Join Text
CONCATENATE joins text pieces. It still works for compatibility, but it cannot take a range — CONCAT and TEXTJOIN replaced it.
Read article →Text
Excel Text functions explained with syntax, examples and common mistakes.
MIDB Function in Excel: Middle Bytes
MIDB Function in Excel: Middle Bytes
TextLevel: ExpertAvailable in: Excel 2007+MIDB is the byte-based version of MID; identical to MID in English setups.Syntax=MIDB(text,2,3)ArgumentWhat it.
Read article →TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TextLevel: IntermediateAvailable in: Excel 2019+TEXTJOIN joins a range of text with a delimiter and can ignore empty cells.Syntax=TEXTJOIN(delimiter.
Read article →JIS Function in Excel: Half-Width to Full-Width Characters
JIS Function in Excel: Half-Width to Full-Width Characters
JIS converts half-width characters to full-width (double-byte), mainly for Japanese documents. It is available only when Japanese is enabled as an editing language (File…
Read article →PHONETIC Function in Excel: Furigana Reading of Japanese Text
PHONETIC Function in Excel: Furigana Reading of Japanese Text
PHONETIC returns the phonetic (furigana) characters stored with Japanese text typed on a Japanese input method. Text without stored furigana (anything typed in English,…
Read article →ASC Function in Excel: Full-Width to Half-Width Characters
ASC Function in Excel: Full-Width to Half-Width Characters
ASC converts full-width (double-byte) letters and katakana to half-width. In English text there is nothing to convert, so text comes back unchanged.
Read article →DBCS Function in Excel: Half-Width to Full-Width (Older Name)
DBCS Function in Excel: Half-Width to Full-Width (Older Name)
TextLevel: ExpertAvailable in: Excel 2007+DBCS is the older name of JIS, converting to full-width characters.Syntax=DBCS(text)ArgumentWhat it.
Read article →REGEXTEST Function in Excel: Does Text Match a Pattern?
REGEXTEST Function in Excel: Does Text Match a Pattern?
REGEXTEST returns TRUE if text matches a regular expression — validate PAN numbers, emails or codes in one formula.
Read article →SEARCHB Function in Excel: Search Position in Bytes
SEARCHB Function in Excel: Search Position in Bytes
TextLevel: ExpertAvailable in: Excel 2007+SEARCHB is the byte-based version of SEARCH.Syntax=SEARCHB("B",text)ArgumentWhat it meanstextText to work.
Read article →REPLACEB Function in Excel: Replace by Bytes
REPLACEB Function in Excel: Replace by Bytes
TextLevel: ExpertAvailable in: Excel 2007+REPLACEB is the byte-based version of REPLACE.Syntax=REPLACEB(text,1,2,"**")ArgumentWhat it meanstextText to.
Read article →BAHTTEXT Function in Excel: Number to Thai Baht Words
BAHTTEXT Function in Excel: Number to Thai Baht Words
BAHTTEXT writes a number as Thai text with 'Baht'. There is no rupee equivalent built in; for Indian amounts in words you need a…
Read article →LENB Function in Excel: Length in Bytes
LENB Function in Excel: Length in Bytes
LENB returns the number of bytes; identical to LEN in English setups, double for East Asian characters when a DBCS language is set.
Read article →