Problem in inserting strings and numbers using right to left language
 

Hello,

I have a text string that contains both English and a Right to left
language (Hebrew)

I try to create with a regular Excel formula (not VBA) a new string
formed of the previous one + a new string composed of numbers
separated by a "~" sign (Mixed string&"~"&Number )

The problem is that the result is a new string where the number string
is in the middle and the English part of the first string at the end

Thanks for your help

Avi