ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unicode entries (https://www.excelbanter.com/excel-discussion-misc-queries/237227-unicode-entries.html)

danpt

unicode entries
 
In any cell I typed in the followings:
ESifhpef;pef;OD;
When I edited it with a space in between h and p, it changed to;
Esifh pef;pef;OD;
Notice the Ucase of S changed to Lcase s
How to I set up Excel not to do that? It matters for unicode entries.

Luke M

unicode entries
 
Under Tools-Auto Correct Options, uncheck the "Correct two intial capital"
option. (or create an exception rule)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"danpt" wrote:

In any cell I typed in the followings:
ESifhpef;pef;OD;
When I edited it with a space in between h and p, it changed to;
Esifh pef;pef;OD;
Notice the Ucase of S changed to Lcase s
How to I set up Excel not to do that? It matters for unicode entries.


danpt

unicode entries
 
Thank you much, Luke

"Luke M" wrote:

Under Tools-Auto Correct Options, uncheck the "Correct two intial capital"
option. (or create an exception rule)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"danpt" wrote:

In any cell I typed in the followings:
ESifhpef;pef;OD;
When I edited it with a space in between h and p, it changed to;
Esifh pef;pef;OD;
Notice the Ucase of S changed to Lcase s
How to I set up Excel not to do that? It matters for unicode entries.



All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com