I am trying to figure out how to copy empty cell value to grid. In excel if i copy empty cell value to different cell, it would put in a Carriage return in to the cell. Same thing would happen if i were to copy the empty excel cell to a notepad. However, if i were to copy the empty excel cell to a grid view cell, it would not work. All other copied values would simply work. So how can i get the empty cell to be copied to grid view, just like an excel copy & past?