Merge a cell based on count of characters

[Red2003XLT]

Hello All.

How do I?, Merge a cell based on total number of characters?

My rawdata file from Access contains a memo field that may/maynot have more
then 255 characters.

The field is called "Description".

 

[Red2003XLT]

BTW: A Memo field in Acces can contain up to 65,000 characters. Try to make
a nice and tidy report is rather cumbersome in Access so I'm trying Excel

 

[ShaneDevenshire]

Hi Red,

First Excel will not support 65K characters of text in a cell. The max is
32,767 but only 1024 will display.

You can try putting the memo field's contents in an Excel Text Box or
AutoShape, but I don't know their limits.

Merging cells will not help you beat these limits.

 

[Red2003XLT]

ehank you the quick reply;
It appears some of the scribes are routinely typing 1000 characters per entry.

I don't not know the difference between an Access text box and a Excel text
box.
I know very little about Excel.
Just did a Len() Name field averages 50-100characters
The Description field can average 1000 characters
Any suggestions?

 

[ShaneDevenshire]

Hi,

This is a continuation of another thread I responded to -

In either 2003 or 2007 you will be limited to 32,767 characters in a cell
regardless of the version or techniques you use.

Actually Excel 2007 will display far more than 1024 characters in the cell
without pressing Alt+Enter between each 100 characters, in fact it will
display 32,767 characters per cell.

The advantage of using the text box, auto shape or comment is that you don't
need to deal with the Alt Enter issue. In addition these options don't
require you to resize the spreadsheet rows and columns so you can see the
entry.

In addition you can use the Camera tool to shoot the text box or auto shape
and them place a live picture of the object anywhere you want.

The advantage of the Comment is that it will hide when you are not hovering
over it which means that it takes up even less screen space.

For what its worth text boxes and autoshapes can contain more than 32,767
characters, closer to about 40,112. However, it appears that comments don't
allow quite that many characters, jsut 32,767.