Problem in inserting strings and numbers using right to left language

A

avi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Direction problem in inserting strings using right to left language 1
Problem changing numbers in a string 5
Mapping strings to integers 6
leading zeros using ActiveCell.Offset().value to insert row and value 84
Using Styles In An Outline 0
Book formatting: need to alternate page number on left and right margin for only first page of each 2
Len and InStr problem manipulating strings 3
VBA question: How to extract cell values in different languages 10

Top