CAD tip # 11580:

Question CAD
% platform category

Excel: convert Unicode texts to \U+ codes for AutoCAD

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:

ACADLT

* CAD

28.8.2017 8547×

Comments Tell a friend

Prices - CAD eShop:

AutoCAD

AutoCAD LT

applies to: AutoCAD · AutoCAD LT ·

See also:
Tip 13139:	How to insert a new line into multiline text in the Find/Replace command?
Tip 12863:	Do you know the difference among the fonts ISOCP, ISOCP2 a ISOCP3?
Tip 12782:	How to insert a character in Kanji or Pinyin into Fusion 360?
Tip 12562:	How to display cyrillic or special math symbols in a DCL dialog?
Tip 12181:	Using a YES/NO parameter in Revit schedules.

Selected tip: How to record a walkthrough animation in AutoCAD 2007?

Back All CAD Tips

How to compare changes between two versions of a Revit BIM project? « | » What is the Linked account in your Autodesk Account profile?

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link:

CAD: OS: Categ:
Text:	FAQ glossary

Featuring:
Link your AutoCAD block attributes with Excel tables/sheets. Automatically. Dynamically. Bidirectionally.
Try Excellink 2015 More info

Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, Forma, 3ds Max and other Autodesk software (support by Arkance Systems) - see About	Arkance Systems CZ s.r.o. (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner	CONTACT: webmaster.cz@arkance-systems.com tel. +420 910 970 111
	Copyright © 2024 \| Advertise with us \| Online privacy

CZ \| EN \| DE
Login or
registration
	Visitors: 7207