Dear all

Currently, i meet an excel problem.

I have a lot of cell with text length different.
For 1 cell:
I want to break line in the same cell with limited 30 characters automatically.
No matter how large the length of the cell, each line can only have 30 characters.
For those extra characters, they will be move to the next line (in the same cell).
And i do not want to use Macro.

Anyone can help on this please?

Thanks a lot