I have a workbook that was created in Excel 07 but saved as 03. The A column
has text that can be larger than the width but I don't want to format the
width to the text. Column B has the following formula:
=IF(ISNA(VLOOKUP(A5,Inventory!$A$2:$B$3000,2,FALSE )),"",VLOOKUP(A5,Inventory!$A$2:$B$3000,2,FALSE))
(Thanks to techonthenet.com for the help on the ISNA trap.)
Column A usually has the 6 digit item number and column B has the results.
There are a few times that more than 6 digits needs to be typed in the
column A and printed such as "100 are for a special order". In 07, it is not
printing the entire text on the paper but cutting it off at the end of the
cell width.
How can I get the cell contents to fully print without adjusting the column
width? If all else fail, I can type it in column C and have it there.
Thank to all for reading and replying.
Lee

You could allow the text to wrap (Format | Cells | Alignment tab -
click on Wrap Text), although you will need to increase row height to
see it all, and that might mess up what the rest of the data looks
like (by default it is oriented to the bottom, but you could set it to
centre vertically).

Hope this helps.

Pete

On Oct 14, 8:46 pm, "Neophyte" wrote:
I have a workbook that was created in Excel 07 but saved as 03. The A column
has text that can be larger than the width but I don't want to format the
width to the text. Column B has the following formula:
=IF(ISNA(VLOOKUP(A5,Inventory!$A$2:$B$3000,2,FALSE )),"",VLOOKUP(A5,Inventor*y!$A$2:$B$3000,2,FALSE) )
(Thanks to techonthenet.com for the help on the ISNA trap.)
Column A usually has the 6 digit item number and column B has the results.
There are a few times that more than 6 digits needs to be typed in the
column A and printed such as "100 are for a special order". In 07, it is not
printing the entire text on the paper but cutting it off at the end of the
cell width.
How can I get the cell contents to fully print without adjusting the column
width? If all else fail, I can type it in column C and have it there.
Thank to all for reading and replying.
Lee