## How to use DBCS Function in Excel

DBCS function in excel is a text/string function. Its full form is (Double Byte Character Set). This function is used to convert single byte characters …

Skip to content
# Category: text strings

## How to use DBCS Function in Excel

## How to use CONCAT Function in Excel

## How to use UNICODE Function in Excel

## How to use TEXTJOIN Function in Excel

## How to use UNICHAR Function in Excel

## How to use the Excel T function

## How to use the Excel VALUE function

## How to use the Excel UPPER function

## How to use the Excel TRIM function

## How to use the Excel SUBSTITUTE function

Excel is easy to learn

A text string, also known as a string or simply as text, is a group of characters that are used as data in a spreadsheet program. Text strings are most often comprised of words, but may also include letters, numbers, special characters, the dash symbol, or the number sign. By default, text strings are left-aligned in a cell while number data is aligned to the right.

DBCS function in excel is a text/string function. Its full form is (Double Byte Character Set). This function is used to convert single byte characters …

The Excel CONCAT function concatenates (joins) values supplied as references or constants. Unlike the CONCATENATE function (which CONCAT replaces), CONCAT allows you to supply a …

The Excel UNICODE function returns a number (code point) corresponding to a Unicode character in decimal format. Unicode is computing standard for the unified encoding, …

The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply a range of cells, and …

The Excel UNICHAR function returns a Unicode character based on a given number. Syntax:= UNICHAR (number) The UNICHAR function syntax has the following arguments: Number …

The Excel T function returns text when given a text value and an empty string (“”) for numbers, dates, and the logical values TRUE and …

Value function in Excel gives the value of a text which represents a number for example if we have a text as $10 this is …

The UPPER function is an Excel Text function, that will convert text to all capital letters (UPPERCASE). Thus, the function converts all characters in a …

Trim function in excel as the name suggests itself it trims some part of any string, why string because it is a text function, the …

Substitute function in excel is a very useful function which is used to replace or substitute a given text with another text in a given …