Hi All,
I am looking for an macro which will compare two columns only for digits and if result were equal than translate/replace those digits with respective language.
Find: 1234567890
Replace: १ २ ३ ४ ५ ६ ७ ८ ९ ०
Column1 Column2 comparision result this is test 234 message. this is test 234 message. test 567 message. is test 567 message.
Last edited by ShailShin; 05-21-2014 at 01:49 AM.
Please show the expected result also
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi,
Please find below output...
Column1 Column2 comparision result this is test 234 message. this is test २३४ message. True test 567 message. is test ५६७ message. True test 890 message. is test ८९० message. False
In C1 Cell
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,"१"),2,"२"),3,"३"),4,"४"),5,"५"),6,"६"),7,"७"),8,"८"),9,"९"),0,"०")=B1
Drag it down...
Add this formula and got the result as false and true. However, it does not replace the column 2 digits with translated one.
Thanks,
Shailshin
For translation using this part
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,"१"),2,"२"),3,"३"),4,"४"),5,"५"),6,"६"),7,"७"),8,"८"),9,"९"),0,"०")
Awesome! Works as per the requirement.
Awesome! Works as per the requirement.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks