a cell can hold 32K characters.

I created a table in word 3 rows x 3 columns, and put a bit over 500
characters in each cell. I pasted that into Excel with no problem. I
increase the characters per cell in the table to over 1500 and again pasted
with no problem. (Note that Excel only displays approximately 1024
characters in the cell if no hard returns, but all characters are visible in
the formula bar if you select the cell. This was a manual copy and paste.
Not sure how you are doing it. There are some limitations to 255 characters
when passing strings in code.

Regards,
Tom Ogilvy


"sallie" wrote in message
...
I am working with Office XP and I have created a custom
form in Outlook. Because of its limitations with writing
to other applications I have created a table view in
Outlook that will allow me to copy and paste into Excel.
It does not appear that there is a limit to the text box
in Outlook, but when I try to paste text into Excel it
truncates it at 255 characters. I do not work alot with
Excel, and therefore not sure what the limitations on the
size of a field might be. Any help on where to look for
help would be appreciated.