| 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 | |||
Linear Mode
