REVscene Automotive Forum - View Single Post - For the Excel Pro: Cell Formatting Question?

Ferra · 01-07-2011, 09:27 AM

you know when a text is too long to fit inside a cell, the last portion of the text usually just get cut off...

I am wondering if it is possible to format the cell such that...the last portion of the text becomes "..." or "~" if the text is too long to fit inside the cell.

For example:
If I have this text: "superduperwalala" in cell A, and anything after "superdup" gets cut off...i want it to display something like "superd..." or "superdu~" instead.

**I know I can autofit, resize text, wrap text, merge cell....etc, but I don't want that because I want to keep the format uniform.

01-07-2011, 09:27 AM	#1
Ferra I don't like cheese but I love milk! Join Date: Nov 2002 Location: Van Posts: 1,980 Thanked 895 Times in 243 Posts Failed 105 Times in 49 Posts	For the Excel Pro: Cell Formatting Question? you know when a text is too long to fit inside a cell, the last portion of the text usually just get cut off... I am wondering if it is possible to format the cell such that...the last portion of the text becomes "..." or "~" if the text is too long to fit inside the cell. For example: If I have this text: "superduperwalala" in cell A, and anything after "superdup" gets cut off...i want it to display something like "superd..." or "superdu~" instead. **I know I can autofit, resize text, wrap text, merge cell....etc, but I don't want that because I want to keep the format uniform.