Wrap text in a formula cell

[RANDY IN NC]

I have a Sheet that uses vlookup to get information from another sheet... the information is text, and on the source sheet it will wrap... but on the sheet that contains the lookup formula, I cannot get it to wrap that text..

What can I do...

Thank you Randy

[oldchippy]

Hi,

Can't you just apply text wrapping on the cell with the formula?

[RANDY IN NC]

I tried that but it will not wrap in excel 2007... I have not checked it in older versions.... I will look, but I do need it to work in this version..

What else can I try..

Thanks Randy

[RANDY IN NC]

In working with the problem I put in some wrapped text on the input sheet... it did not wrap on the sheet with the lookup formula.... Had to leave for awhile.. saved and closed... came back opened the workbook and the text was wraped on both sheets... It works but I don't understand why it would not show right without saving and closing...

I checked it in both excel 2000 and 2007.. It was the same..

Why?

Thanks Randy

[oldchippy]

I tried it both in 2003 and 2007 and had no problem?? Worked OK in both even without saving the file first.