No. of characters in an Excel column


S

suroora

I just exported data from an Access database into Excel. One of the fields is
descriptive text, roughly between 400-500 characters. However, when I export
it into Excel, the field is truncated because Excel's limit is 250
characters. Is there any way to change this? I tried copying and pasting one
of the entries into Excel, and that seems to work. Do I have to do this
individually for each one, or is there a way of telling Excel to expand the
cell to fit all the content? It's a large database, so I really don't want to
copy and paste the entries individually.

Help!
Suroor
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top