Align mixed Text (english & hebrew) to the Right

Hello everyone

I'm trying to connect Hebrew and English text RANGE(A1:A4) (see example in the attached file)

The connected Text (RANGE(B6) is displayed in wrong order, but when I look at the characters themselves COLUMN(D)

They appear in the correct order...

Any ideas how to display the text in the correct order?

It seemed that if we add char(31) as a delimiter, could solve the problem :

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Thank you

The problem is solved

You are welcome, glad to help.


Regards