How to make visible all text in cell with word wrap on

A

Al

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top