Excel: Assigning values


Hi All, I have a excel like below in the C column and D column C D ا A ء A ب B ت T ث TH ج J ح H خ KH د D ذ DH ر R ز Z س S ش SH ص S ض D ط T ظ Z ع A غ GH ف F ق Q ك KH ل L م M ن N ه H ة H و W ي Y ى Y لا LA ال AL I want to write a macro that whenever I type ا this needs to be changed to A in the column A and B. If I change/add anything in C column, it should work. Can someone help me on this.


This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of June 30, 2014.


For more resources for Microsoft Excel