[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2115
  • 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
 
DreamboatCommented:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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