Re: Any ideas how to copy more than 1024 characters?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Copy from the Formula bar which will contain all the characters, not just
the displayed characters.

Or when concatenating, add an Alt + Enter every 100 characters.

How are you concatenating together?


Gord Dibben MS Excel MVP


On Mon, 13 Apr 2009 11:28:28 -0700, toolman74
<toolman74@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have a spread*** where users fill in data and then copy a single cell to
then paste a large paragraph that I have concatenated together using the
input. They are needing to paste the data into various Word and internet
apps. I now needed to add more data into the paragraph to be copied and I
seem to have reached the max characters the cell will display so the paste is
not complete. Any ideas how to work around this with an easier route than
copying and pasting mulitple cells? Thanks!!

.

Quantcast