Converting full-width and half-width characters in Excel (ASC, JIS, Power Query)
How to bulk-convert between full-width (zenkaku) and half-width (hankaku) characters in Excel. ASC/JIS functions, find-and-replace, Power Query, and VBA approaches with their tradeoffs.
· 3 min read