Left-to-right

[talvd]

Hi,

I have a problem with text data in Hebrew that has been written wrongly, from left to right. As you may know, Hebrew words are to be written and read from right to left.

Let me give you an example, but in English. I have English text, but it is written in each cell from right to left. Let's say the word "complaint" is written "tnialpmoc". If it would only be in some cases I would have repaired everything manually, but I am talking about a dataset of thousands of cases like this.
How can I repair this?

Thanks in advance!

Tal

 

[Domski]

This UDF should reverse the letters in a word:

Public Function REVWORD(myrange As Range) As String
Dim x As Long
For x = Len(myrange.Value) To 1 Step -1
REVWORD = REVWORD & Mid(myrange.Value, x, 1)
Next x
End Function

Hope it helps,

Dom

 

[talvd]

Thanks a lot! I will try it, Domski