I am importing data from access file to a spreadsheet. One of the input field is a "comment" field with a full paragraph of comments. Some of the target cells in the spreadsheet displays "##########". But when I click on the cell, the Menu bar on top of the spreadsheet displays a large amount of data (text values) about a paragraph long.
I am assuming the column/cell is too small to hold that amount of data. I have tried to expand the column, but it's not working
I tried using a MergeCell function to merge some cells so as to have room to stretch out the data, but It's giving me weired message that it can only display the top most data or some stuff like that.
How can I resolve this, any ideas?
Thanks everybody for your input.