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?