as you can see, the hebrew text keeps the RTL rule, but the numbers looses the LTR, and breaks up where the spaces are, into RTL, is there any way to keep each column in its own rule and still combine them into one string?
Trying to use flash fill reveals, the string is correct inside the formula bar, but not inside the cell.
With Power Query there is a way to inverse text.
However flash fill can do what you are after. I managed after some trial and error however.
in C2 type this 1212 8806 ברוך לייב
in C4 type again the correct example.
then Select cells C2:C5 and press CTRL+E (Excel 2013 or later).