Skip to main content

Excel DBCS Function

The DBCS function converts half-width (single-byte) characters into full-width (double-byte) characters in a text string.

dbcs-functionn 1


Syntax

=DBCS(text)


Arguments

  • Text (required):The text or cell reference that contains the characters you want to convert to double bytes.

Return Value

The DBCS function returns a text value..


Function notes

  1. The name of the function (and the characters that it converts) depends on your language settings.
  2. For Japanese, the DBCS function converts half-width (single-byte) English letters or katakana to full-width (double-byte) characters.
  3. If no half-width (single-byte) letters are in a text, the text is not changed.
  4. The DBCS function is introduced in Excel 2013, so it is not available in earlier versions of Excel.

Example

As the below screenshot shows, there are some texts in half-width (single-byte) letters in the range. To convert them to texts in full-width (double-byte) letters, please do as follows.

1. Please copy the formula below into cell D6, then press the Enter key to get the result.

=DBCS(B6)

dbcs-functionn 2

2. Select this result cell and drag its autofill handle down to get the rest of the results.

dbcs-functionn 3

Relative Functions:

  • Excel EVEN Function
    The EVEN function rounds numbers away from zero to the nearest even integer.

  • Excel EXP Function
    The EXP function returns the result of the constant e raised to the nth power.

 

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations