Hello every one,
I have to convert an old dos program file to excel. I already have the list in excel but the text is in strange symbols. I know which symbol represents which
letter. As have many files to convert each time I need a makro which would save me lot of time.
I have two worksheets: "1" and "2". I need a makro which replaces symbols in sheet "1" Column A through key list in sheet "2".
Example:
____________________________________
Before:
"1" Column A
stra~e
m§ger
§u~ere
wei~
w+&tte
searچ
"2" Column A-------------Column B
~ ------------- ss
§ ------------- Ae
+& ------------- a
چ ------------- ch
after running the makro sheet "1" should become:
"1" Column A
strasse
mAeger
Aeussere
weiss
watte
search
_____________________________________
Its very important that the replacement takes place one after another according to the order in key list of "2". That would mean according to our example
that the the third entry in column A "§u~ere" would become in first step "§ussere" because the key for "~" has first position. After the replacement of "~"
to "ss" is complete then the next replacement should be done. And so on...
In example i have used only few rows but the real text contains of many thousand cells in sheet "1" and many dozens symbol and their keys in sheet "2".
Thank you very much for each assistance.
Bookmarks