View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Aaron is offline
external usenet poster
 
Posts: 287
Default wrapping text and vlookup

Hi, nice suggestion, no go on my cells though... must be something else going
on somewhere I think.

"Kevin Vaughn" wrote:

In extremely limited testing, format-row-autofit seemed to do the trick.
--
Kevin Vaughn


"Aaron" wrote:

Hi

Bit of a strange one this, I have a vlookup formula that returns long text
strings. I'd like to have the cells wrap the text when necessary, however
excel won't apparently allow this to happen - with the wrap text box checked
the text doesn't wrap. Does anyone know if this is a result of the use of the
vlookup, and is there any way around it?

Thanks