Over 1.095.000 registered users (EN+CZ).
AutoCAD tips, Inventor tips, Revit tips.
Try the new precise Engineering calculator.
New AutoCAD 2026 commands and variables.
CAD tip # 11580:
Question
A
With the following VBA macro you can use Excel to convert any Unicode text (cyrillic - russian, arabic, chinese, japanese, korean, greek and other two-byte characters) to encoded text for AutoCAD. Such encoded text can be then pasted into an AutoCAD text object. If such text object uses a text style based on an appropriate font (containing foreign-language characters), the text will be properly displayed in any AutoCAD version.
The custom function ACADunicode:
The code of the VBA function (Alt+F11 in Excel, Insert>Module):
Function ACADunicode(s) cvt = "" For i = 1 To Len(s) c = Mid(s, i, 1) x = StrConv(c, vbUnicode) If Mid(x, 2, 1) = Chr(0) Then cvt = cvt & c Else cvt = cvt & "\U+" & _ Right("0" & Hex(Asc(Mid(x, 2, 1))), 2) & _ Right("0" & Hex(Asc(Mid(x, 1, 1))), 2) End If Next i ACADunicode = cvt End Function
You can invoke in Excel in a standard way, similarly as other embedded functions - e.g. =ACADunicode(A1) - converts the text from the cell A1.
The resulting text in AutoCAD:
ACADACLT


28.8.2017
9932×
applies to: AutoCAD · AutoCAD LT ·