text limit using a vlookup
I'm using the vertical lookup function to fill in cells in a spreadsheet and
for whatever reason part of the text gets cut off at the end. There are a good 20+ characters left off. When I open both files (the looker upper and the looker frommer) all of the text is filled in. Why does this happen, and what may be a solution? |
text limit using a vlookup
You'll only get 255 characters back when the "sending" workbook is closed. If
you open the sending workbook (and recalc), you'll get the all the text. I don't know a workaround. (It's not just =vlookup()'s, either.) Dave D wrote: I'm using the vertical lookup function to fill in cells in a spreadsheet and for whatever reason part of the text gets cut off at the end. There are a good 20+ characters left off. When I open both files (the looker upper and the looker frommer) all of the text is filled in. Why does this happen, and what may be a solution? -- Dave Peterson |
All times are GMT +1. The time now is 06:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com