Bug fixed for Daw
Pre-release
Pre-release
Release Notes
- In the initial release v1.0a, the algorithm won't recognize the word ဒေါ် (Daw) and it would just leave it out of the returning text string and therefore added a constant for moutcha (ါ).
- With this version, MMRManipulator UDF has been updated to give the user more refined control over how the output string was separated by allowing the user to define the delimiter (or not) even right down to the left or right one!
Now, MMRManipulator has to be called like=MMRManipulator(whichCell, leftDelimiter, wordSeparator, rightDelimiter, reversedOrder)and an example call would be like: if Cell A1 contains, အောင်မြင့်မြတ် then from inside Cell B1,=MMRManipulator(A1,"""",",",CHAR(34),FALSE)and the return would be something like "အောင်","မြင့်","မြတ်" just like a Python list.
Thus, added 2 extra parameters for leftWraper and rightWrapper. - Also included in Sheet3 of the .xlsm file are:
i. word count formula (sample)
ii. formula to split each word into a column (sample).
The formulas are just minimal and of course, the users can edit and/or use whatever formula they desired.
Further information on using formulas can be found in their relevant sections.