Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hebrew inverted characters macro
Hi. Im working rapidly with hebrew reports that was converted from dos Allmost everything is going well after the convertion except that th words, that mainly in hebrew(right to left) are shown in inverte character order. exaple: "Words" are shown as "sdroW". i cannot find any macro that runs on the worksheet and divert i back.... can someone help me here PLS ???? Tnx a Lot, Morris ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hebrew inverted characters macro
Morris
I picked this up from somewhere, I not where but I'd guess it came from the NG at some point: Function ReverseWord(sContents As Variant) As Variant If sContents = "" Then ReverseWord = "" Exit Function End If If sContents = True Or sContents = False Then ReverseWord = Not sContents Exit Function End If Dim i As Integer For i = Len(sContents) To 1 Step -1 ReverseWord = ReverseWord & Mid(sContents, i, 1) Next 'i If IsNumeric(sContents) Then ReverseWord = ReverseWord * 1 End Function So, to reverse cell A1, you would use: =ReverseWord(A1) You could set up a new sheet and reverse the words in the cells on the original sheet (as one option) For example, in cell A2 on Sheet 2, you could have: =reverseword(Sheet1!A2) Regards Trevor "morris" wrote in message ... Hi. Im working rapidly with hebrew reports that was converted from dos. Allmost everything is going well after the convertion except that the words, that mainly in hebrew(right to left) are shown in inverted character order. exaple: "Words" are shown as "sdroW". i cannot find any macro that runs on the worksheet and divert it back.... can someone help me here PLS ???? Tnx a Lot, Morris. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tsv file open in turkish font and it should be hebrew why ? | Excel Discussion (Misc queries) | |||
hebrew dates | Excel Discussion (Misc queries) | |||
Sort by Hebrew Date | Excel Discussion (Misc queries) | |||
can text be inverted by 180deg | Excel Discussion (Misc queries) | |||
Insert Hebrew Date | Excel Worksheet Functions |