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