Forum Discussion
Meekou
Jul 29, 2024Copper Contributor
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 wit...
HansVogelaar
Jul 29, 2024MVP
> 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).
- MeekouJul 29, 2024Copper ContributorIt did not make sense, because, it works at other PCs for same language.
- HansVogelaarJul 29, 2024MVP
Are you sure that there were no spaces between the characters?
- MeekouJul 29, 2024Copper ContributorYes, I did test with same chinse characters..