Excel vs Strings > 255 characters

Article View: comp.sys.mac.apps

Article #11646

#11646

From: Paul E. Jacoby
Date: Tue, 12 Jan 1993 03:25

20 lines
1297 bytes

Is there any way to get Excel 4.0 to deal with a string which is GREATER
than 255 characters in length?  I'm writing a macro to compile a bunch
of data, and need to be able to get more than 255 characters into one
cell.  Thus far, I split my 'collector' string into to separate names,
keeping each below the 255 character threshold.  However, the only way I
can see to get both items into the same cell is to do a

   FORMULA(save1&save2, reference)

and this of course truncates the strings at 255 characters TOTAL.

Help!  Surely there is a good way to do this kind of thing...e-mail and
posted replies appreciated!

   Paul
-- 
| Paul E. Jacoby, Consultant  | pejacoby@mmm.com      CIS:70404,2507 |
| David Mitchell & Associates |                                      |
| 3M Center, Bldg 235-3F-27   |--------------------------------------|
| Maplewood, MN   55144-1000  | (612) 737-3211 [w]      731-6392 [h] |

Technical Details

Message-ID: <1993Jan12.032515.25136@mmm.serc.3m.com>

Path:

arc1-ca.pugleaf.net!sparky!uunet!paladin.american.edu!howland.reston.ans.net!spool.mu.edu!umn.edu!mmm.serc.3m.com!pejacoby

Show Full Headers

Complete Article Headers

Newsgroups: comp.sys.mac.apps
Path: arc1-ca.pugleaf.net!sparky!uunet!paladin.american.edu!howland.reston.ans.net!spool.mu.edu!umn.edu!mmm.serc.3m.com!pejacoby
From: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Subject: Excel vs Strings > 255 characters
Message-ID: <1993Jan12.032515.25136@mmm.serc.3m.com>
Organization: 3M Company
Date: Tue, 12 Jan 93 03:25:15 GMT
Lines: 20