First, Widechar
function Purpose: Converts single-byte characters to double-byte characters.
Grammar:
Widechar (text)
Description: Text is a literal that needs to be converted to double-byte characters or a cell reference that contains text.
Note: Because the Chinese character itself is a double-byte character, the use of this function to convert Chinese characters is the original form of the Chinese character.
Examples are as follows:
The formula "=widechar" ("Dzwebs") returns Dzwebs
=widechar ("VW computer") returns to "Volkswagen Computer".
Second, ASC
Purpose: Converts full-width characters into half-width characters.
Grammar:
ASC (text)
Parameters: Text to find its length.
Description: The formula converts full-width letters to half-width letters and remains unchanged if no full-width letters are included.
Examples are as follows:
Assuming that the contents of the B6 cell are mass Excel, the formula "=ASC (A1)" returns to public Excel.
From Excel to Excel, you change from double byte to single byte, which means that the whole corner becomes half a corner.