View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
suroora suroora is offline
external usenet poster
 
Posts: 6
Default No. of characters in an Excel column

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