So I’ve just learned the Excel will only display the first 1024 characters of a longer string of text in a single cell.
I know how to use the len function to count the number of characters in the cell.
So, if the length turns out to be more than 1024, can you suggest a scheme to chop up the long string into ones of <1024, and put each of the shorter strings into successive cells, so the entirety can be displayed?
FYI, the spreadsheet is used to summarize course evaluations turned in by students. Most of the data is numeric and can literally be summed up, but there are free text comment lines, and some students seem to be writing short stories rather than comments.
If you don’t mind using a macro, I’d be happy to write a quick bit of VBA that will do this for you. PM me if you’re interested so I can get the details from you. If you need a non-macro solution, I’m afraid it’s beyond my ken, but best of luck. (I believe it can be accomplished using IFs in the cell formula, but being a programmer I always resort to macros to do this sort of thing. When all you have is a hammer, and all that…)
Thanks for your offer, Roland, but I’m trying to make this work without any input from the user, other than typing in the string. I’m also not yet at the point where I could give you enough specifics to write a macro.