Forum Discussion
Format cells with distributed indent not working
I have entered value in cell
I am trying to format chinse string to keep same width like below:
I try to set with below
But, it did not take effect, its result like format with center
until I enter space between 一 and 二, it will be like
It seems excel treat 一二 as single words instead of two words
5 Replies
> It seems excel treat 一二 as single words instead of two words
That is correct. Distributed alignment uses the spaces in a cell value to spread the text. If there are no spaces it cannot do that. So it fails for a language where one character = one word.
You can report this from within Excel: Help > Feedback > Report a problem (or Make a suggestion).
- It did not make sense, because, it works at other PCs for same language.
Are you sure that there were no spaces between the characters?
