Address can not be more than 30 characters

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,
I have a report that is opened through excel and it includes an address
column. I am sending this report to a thrid party who can not have the
address field be more than 30 characters. Is there a formula that would
recognize if the field is more than 30 characters and then move the extra
characters to the next column? the report includes over 1,000 records so it
would be nice if I did not have to do any manual work.

Thank you,
.

Relevant Pages

  • RE: 255 Character Limit for Linked Excel data
    ... Excel sheet as a text document. ... The data in column A is truncated at 255 characters in the Access ... So I made sure I did this -- but I still have the truncation issue. ... I opened my report in design view and got the properties for the Text ...
    (microsoft.public.access.externaldata)
  • Re: Truncated fields when Report analyzed in Excel
    ... Allen Browne - Microsoft MVP. ... Memo Field Truncated When Report Is Output to Excel: ... When You Export an Access Report the Memo Field Is Truncated: ... Exported Query Expression Truncated at 255 Characters: ...
    (microsoft.public.access.reports)
  • Re: Truncated fields when Report analyzed in Excel
    ... There is a problem with exporting fields longer than 255 characters. ... When You Export an Access Report the Memo Field Is Truncated: ... I'm having problems when I "analyze" my reports in Excel. ...
    (microsoft.public.access.reports)
  • Re: DEFCON 16 and Hacking OpenVMS
    ... To reproduce this, apparently one is to enter exactly 511 characters ... Of course it could even be Alpha chip type ... Sampsa's report of VMS vulnerabilities in the Defcon 16 slides. ...
    (comp.os.vms)
  • Message body and Excel
    ... I'm planning to use Excel to report the contents of a public folder as ... item can cover several rows (i.e. as many rows as there are return characters ...
    (microsoft.public.outlook.program_forms)