View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
al al is offline
external usenet poster
 
Posts: 363
Default How to make visible all text in cell with word wrap on

I have an SQL query that returns to Excel a "Notes" field which can be 0 -
5000 characters in size. The text can contain CrLf (little square boxes),
and special characters (",:'.).

With WordWrap on I cannot get ALL the text to display. I have set column
type to "General". I understand there is a limit of 1024 visible. The users
would like to have a column width of 60 chars.

Is there a way in VB to format this column to display all the data in
WordWrap format?