WIDECHAR in WPS Spreadsheet: Convert Half-Width Latin Letters to Full Width
Use WIDECHAR for bounded Latin-letter width conversion in WPS, with original mixed-width examples and explicit language-setting limitations.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =WIDECHAR("ABC") has expected text ＡＢＣ in the lesson’s historical double-byte-language context. It changes Latin letter width from half-width to full-width.
Syntax and scope
=WIDECHAR(text)
The required argument is text or a cell reference containing it. The source describes a width conversion, not a change of letter case, spelling or language. The original examples here use only Latin letters in their ordinary and full-width forms.
The official lesson explicitly warns that the function name and converted characters depend on language settings, and separately discusses Japanese kana. This guide does not extend the demonstrated Latin-letter examples to every locale or to kana conversion.
Complete worksheet example
Enter the following text strings in A2:A5. Put =WIDECHAR(A2) in B2 and copy the cell reference down. Copy the source strings carefully: some characters can look similar even though their width forms differ.
| Cell | Input text | Independent expected text |
|---|---|---|
| A2 | ABC | ＡＢＣ |
| A3 | Wps | Ｗｐｓ |
| A4 | ＡＢＣ | ＡＢＣ |
| A5 | AｂC | ＡｂＣ |
The first row changes three uppercase Latin letters. The second preserves the uppercase W and lowercase p and s while changing width. The third is an already-converted control. The fourth mixes width forms and illustrates that the conversion need not change every character.
These expectations use an explicit one-to-one mapping for the chosen Latin letters. They are not an execution of WPS or a claim that an arbitrary Unicode normalization routine exactly reproduces the application.
Advanced use: keep an original and a standardized label
A controlled catalogue may receive otherwise identical Latin labels in different width forms. Keep the incoming text in one column and the converted label in another, rather than overwriting the original immediately. This preserves the ability to inspect unexpected changes and trace the source.
Width conversion is only one normalization decision. It does not make uppercase and lowercase equal, remove spaces, correct spelling or identify duplicate records by itself. For example, Wps and WPS remain distinct case patterns even after their widths are made consistent.
Do not infer identical storage byte counts from how wide the letters look on screen. Full-width characters and their half-width counterparts can have different encoded lengths depending on the encoding used outside the spreadsheet. This function is not a UTF-8 byte-count calculation.
For a carefully controlled Latin-only example, the opposite width mapping provides an independent conceptual check. That does not establish a lossless round trip for every character, punctuation mark or language. Preserve the original whenever reversibility matters.
Boundaries and errors
The official lesson does not supply a complete error table. Blank arguments, numeric coercion, errors in source cells, arrays and unusual symbols therefore have no invented result or error code here.
Digits, punctuation, spaces, kana, emoji and combining sequences are deliberately outside the original control table. A historical screenshot may show additional characters, but a small demonstration is not an exhaustive character-mapping specification. Check those cases separately in the intended WPS edition and language settings before using them in a data-cleaning rule.
The result is text. Changing a label’s width does not make a numeric-looking string a number or establish that two independently supplied identifiers refer to the same item. Treat the conversion as a narrowly defined text transformation.
Evidence and version scope
The official WPS Academy WIDECHAR lesson, published 2019-06-24, has the applicability scope recorded below. It was reviewed on October 18, 2026. The applicability field explicitly names WPS Office for Windows Personal. The numeric build, introduction release and last supported version remain unknown. The source does not identify this function as deprecated or retired. Support in Linux, other editions and other platforms is not established by this lesson.
The worked examples are original mathematical expectations based on the official contract and formula illustration. They were not executed in WPS. Historical vendor demonstrations are documentation, not our application tests; no screenshot or runtime precision guarantee is supplied. English names and comma separators follow the lesson. Localized entry, workbook interchange and exact output formatting require verification in the intended client.