Help: In the same cell, how to break line automatically with limited characters.

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

Originally Posted by :) Sixthsense :)

Contradictory statements

In simple No You Can't do it without using Macro

Thank you Sixthsense, in fait, the excel worksheet has marco to do the transfer. But as i made a lot of vlookup, the marco doesn't work. It keeps calculating endless. lol

Originally Posted by teylyn

Hello,

>> And i do not want to use Macro.

That will not work, then. Excel does not have the functionality you describe built in. The only thing you might want to try is to use a monospace (fixed width) font, but even then this will only work if the text does not have spaces. Excel will not break a word across a line. Instead, it will put the whole word on a new line.

Attachment 431134

In this screenshot you can see that columns B and C have the same width. Column B has spaces and the lines will break at a space. Column C does not have spaces and the lines will break after 7 characters of this monospace font.

cheers, teylyn

Thank you Teylyn.
You are right, i used the Fix width first, and use the automatically adjustment, and then i frozen the column.
It works on worksheet, but not sure when i upload in the label printing system.
I will try. lol