| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No. of characters in an Excel column
Use Method 1 in the following MSKB article, and you should get all the
characters in the export: ACC2000: Memo Field Truncated When Report Is Output to Excel http://support.microsoft.com/kb/208801 suroora wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No. of characters in an Excel column
Thanks, Debra. That worked!
Suroor "Debra Dalgleish" wrote: Use Method 1 in the following MSKB article, and you should get all the characters in the export: ACC2000: Memo Field Truncated When Report Is Output to Excel http://support.microsoft.com/kb/208801 suroora wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set the number of characters in a column | Excel Discussion (Misc queries) | |||
| change Excel column headings from numbers to alpha characters | Excel Worksheet Functions | |||
| adding characters in excel column | Excel Discussion (Misc queries) | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| Remove 1st 3 characters in each field of Excel column | Excel Worksheet Functions | |||
Linear Mode
