Unicode Bidirectional Text Algorithm in Excel

Question

Hi,
I want to know the support of Unicode bidirectional algorithm in Excel.

Embedding and override characters (PDF, LRE, RLE, LRO, RLO) looks like working,
but isolate characters (LRI, RLI, PDI) looks not.

When I enter LRI(U+2066), RLI(U+2067), PDI(U+2069),
excel shows character icon with a broken line.

Do I need some kind of settings to get isolate characters to work?
Or just excel dosent support isolate characters?

I found a similar question, but no answers.
https://learn.microsoft.com/en-us/answers/questions/521271/using-unicode-directional-formatting-characters-in.html

My excel version is
Microsoft® Excel® for Microsoft 365 MSO (16.0.14326.20850) 64 bit version 2108

Answer 1

Hi @fbKH ,

Welcome to Q&A forum~

> I want to know the support of Unicode bidirectional algorithm in Excel.

So far, I haven't found the documentation related to Unicode BiDi algorithms of Excel or Office.

Based on my tests, isolate characters enter in Word and Excel do have the broken lines, and I do not find any settings to remove it.

Following screenshot is using "UniChar" function to enter the isolate characters in Excel.

Following image is pressing Alt+X to convert the Unicode number to get isolate characters in Word.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---