• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2153
  • Last Modified:

text string you entered is too long please reduce the number of characters

folks

i have a marco that copies data to a cell,hence some cells contain 1900 charcters,how can i overcome the

"
text string you entered is too long please reduce the number of characters

"

error

all help will do
0
rutgermons
Asked:
rutgermons
1 Solution
 
Anne TroyEast Coast ManagerCommented:
What version are you using?

I assume you're using Excel...
0
 
rutgermonsAuthor Commented:
yes
0
 
rajuonlineCommented:
MS Excel Allows Maximum 32,767 characters in a Cell. You can't have more than 32,767 characters in a cell.

regards...

Raju
0
 
caddladyCommented:
What method are you using in the Macro to copy the data?

Only 1024 characters will display, but when you look at the cell in the Formula bar - all 32,767 will display.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now