DBCS

Formulas / DBCS
Convert half-width letters to full-width letters.
DBCS(text)
  • text - the text to change or a cell reference to the text to change

Examples

  • =DBCS("Sourcetable")

    The DBCS function can be used to return a string of text exactly as it is entered into the argument of the function. For example this will return "Sourcetable".

  • =DBCS(" ")

    The DBCS function can also be used to return a string of text that includes spaces. This example will return " ", with two spaces between the quotation marks.

Summary

The DBCS function is used to convert text from half-width English letters or katakana to full-width characters. It requires a text argument as input, which is then processed and converted.

  • The DBCS function takes a text argument which is required and is the string to be converted.
  • The function converts half-width letters in a string to full-width letters.

Frequently Asked Questions

What is the DBCS function?
The DBCS function is a tool used to convert half-width letters in a string to full-width letters. It works with English letters and katakana.
Does the DBCS function change text that does not contain half-width English letters or katakana?
No, the DBCS function does not change text that does not contain half-width English letters or katakana.
What types of letters does the DBCS function work with?
The DBCS function works with English letters and katakana.
What type of operation does the DBCS function do?
The DBCS function converts half-width letters in a string to full-width letters.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.