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
rutgermonsAsked:
Who is Participating?
 
caddladyConnect With a Mentor Commented:
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
 
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
All Courses

From novice to tech pro — start learning today.