Text from Referenced cell truncated
in [Functions]
|
Prev: formula similar to "countifs" function in excel 2007
Next: Pivot table to calculate variance showing budget and actual.
From: Jay on 19 Apr 2010 12:20 Good afternoon Everyone, my problem is that text from a referenced cell in a separate workbook is not showing up completely in a secondary workbook. I am aware of the 1024 characters, but on some of these cells, only 200 characters are showing and the rest of the data is not. If I have the origninal workbook open, all the text will show. Any assistance will be greatly appreciated. -- Cheers!
From: Dave Peterson on 19 Apr 2010 12:55 That's the way excel and windows work. You're limited to 255 characters unless you open that sending workbook. Jay wrote: > > Good afternoon Everyone, my problem is that text from a referenced cell in a > separate workbook is not showing up completely in a secondary workbook. I am > aware of the 1024 characters, but on some of these cells, only 200 characters > are showing and the rest of the data is not. If I have the origninal workbook > open, all the text will show. Any assistance will be greatly appreciated. > -- > Cheers! -- Dave Peterson
From: Jay on 19 Apr 2010 14:01
Thanks much.... guess I will try something else, perhaps break it down to a few cells. have a good one !! -- Cheers! "Dave Peterson" wrote: > That's the way excel and windows work. > > You're limited to 255 characters unless you open that sending workbook. > > Jay wrote: > > > > Good afternoon Everyone, my problem is that text from a referenced cell in a > > separate workbook is not showing up completely in a secondary workbook. I am > > aware of the 1024 characters, but on some of these cells, only 200 characters > > are showing and the rest of the data is not. If I have the origninal workbook > > open, all the text will show. Any assistance will be greatly appreciated. > > -- > > Cheers! > > -- > > Dave Peterson > . > |