Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wrapping text and vlookup
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wrapping text and vlookup
Ok. Well, hopefully someone else will proffer a solution.
-- Kevin Vaughn "Aaron" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wrapping text and vlookup
You sure that the text isn't wrapping?
Could it be that the rowheight isn't expanding? If you adjust the rowheight manually, do you see your wrapped text? 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wrapping text and vlookup
Dave
I have the same problem. If I expand the rowheight manually I can see the (text) result of the VLOOKUP function. Is there a way to overcome this? "Dave Peterson" wrote: You sure that the text isn't wrapping? Could it be that the rowheight isn't expanding? If you adjust the rowheight manually, do you see your wrapped text? 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wrapping text and vlookup
Rowheight won't change as a result of a calculation. You'll either have to
manually adjust that rowheight or maybe have an event macro do it for you. If you want to try that event macro, you can rightclick on the worksheet tab that should have this behavior. Select view code and paste this in: Option Explicit Private Sub Worksheet_Calculate() Me.Rows.AutoFit End Sub You could be more explicit, too, by using a line like: Me.Rows("1:15").AutoFit Wouldliktoknowthat wrote: Dave I have the same problem. If I expand the rowheight manually I can see the (text) result of the VLOOKUP function. Is there a way to overcome this? "Dave Peterson" wrote: You sure that the text isn't wrapping? Could it be that the rowheight isn't expanding? If you adjust the rowheight manually, do you see your wrapped text? 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
vlookup on large text in cells | Excel Worksheet Functions | |||
Vlookup of list with text and number | Excel Discussion (Misc queries) | |||
Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
Combining Text and Date for VLOOKUP | Excel Worksheet Functions |