Opv
05-03-2017, 07:58 AM
I have a worksheet within which users may enter words or phrases that include a variety of non-alpha characters. For example, boar/mix, boar-mix, Boar/mix or or any other delimiter and combination of words. I initially wrote a script which converted these entries (as they are entered) so that the sheet would reflect a standardized capitalization for each word in the name, i.e., Boar/Mix, Boar-Mix, etc.
My script works fine when users apply either "/" or "-" as the delimiter; however, one user has used a character which I can't seem to get my script to force the proper case. See, for example, the following:
Ok·cate·uce
I can't seem to identify which character is being for the delimiter. So, I decided to cycle through the characters one at a time and capture the character based on a predefined list of allowed values (all of the lower case and upper case letters) and it works through every step of the process up to the point that of achieving "Ok Cate Uce" however when I apply the last command to replace the spaces with the delimiter character and apply the changes to the applicable cell, Excel automatically changes it back to Ok·cate·uce
I can't figure out why that delimiter works differently from "/" and "-".
Any ideas?
My script works fine when users apply either "/" or "-" as the delimiter; however, one user has used a character which I can't seem to get my script to force the proper case. See, for example, the following:
Ok·cate·uce
I can't seem to identify which character is being for the delimiter. So, I decided to cycle through the characters one at a time and capture the character based on a predefined list of allowed values (all of the lower case and upper case letters) and it works through every step of the process up to the point that of achieving "Ok Cate Uce" however when I apply the last command to replace the spaces with the delimiter character and apply the changes to the applicable cell, Excel automatically changes it back to Ok·cate·uce
I can't figure out why that delimiter works differently from "/" and "-".
Any ideas?