DBCS
Formulas / DBCSConvert 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.
Need help with Formulas?
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.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV