Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
255 Character Limit
I am doing a vlookup command and am it is only returning the first 255
characters. How can I make it return them all? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
255 Character Limit
If you're using =vlookup() to return a value from a closed workbook, then open
that other workbook (and force a recalculation). Closed workbooks will only "send" 255 characters. Colin wrote: I am doing a vlookup command and am it is only returning the first 255 characters. How can I make it return them all? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
255 Character Limit
Thanks, that works perfectly
"Dave Peterson" wrote: If you're using =vlookup() to return a value from a closed workbook, then open that other workbook (and force a recalculation). Closed workbooks will only "send" 255 characters. Colin wrote: I am doing a vlookup command and am it is only returning the first 255 characters. How can I make it return them all? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF not counting properly!! Character limit? | Excel Worksheet Functions | |||
character limit in hyperlink function | Excel Worksheet Functions | |||
How can I change 255 character limit in 'hyperlink' function? | Excel Worksheet Functions | |||
Character limit in an Excel Row | Excel Worksheet Functions | |||
Cell 255 character limit and formula | Excel Worksheet Functions |