Wrap text

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3156910%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EWrap%20text%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3156910%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20need%20help%20in%20wrapping%20an%20Excel%20cell%20by%20length%20of%20the%20word%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3CTABLE%20width%3D%22%5C%26quot%3B45%5C%26quot%3B%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22%5C%26quot%3B45%5C%26quot%3B%22%3Eglastronix%20supplier%20trend%20chart%26lt%3B%5C%2FTD%26gt%3B%26lt%3B%5C%2FTR%26gt%3B%26lt%3B%5C%2FTBODY%26gt%3B%26lt%3B%5C%2FTABLE%26gt%3B%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EColumn%20width%20should%20be%20automatically%20adjusted%20to%20the%20word%20length.%26nbsp%3B%20When%20I%20use%20wraptext%2C%20sometimes%20one%20word%20is%20getting%20split%20and%20coming%20in%20two%20lines.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ecan%20anyone%20help%20in%20this%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3156910%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Visitor

Hello,

 

I need help in wrapping an Excel cell by length of the word

 

glastronix supplier trend chart

 

Column width should be automatically adjusted to the word length.  When I use wraptext, sometimes one word is getting split and coming in two lines.

 

can anyone help in this

1 Reply

@nitheshck 

Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break.

Wrap text in a cell

 

or...

 

Write in a line below each other

How can I write one column below the other in Excel?

image result Write permanently in Excel cells below each other Open Excel

and press the [Ctrl] + [1] keys at the same time.

Then switch to the "Alignment" tab in the "Format Cells" window.

Under the "Text Control" you will now find the "Wrap Words" option.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)