View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn Kevin Vaughn is offline
external usenet poster
 
Posts: 111
Default wrapping text and vlookup

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