Instead of copying part of the data to the cell below, try to wrap the txt in
one cell.

Select the cells,

Press Ctrl + 1
Select tab "alignment"
Choose "word Wrap"

This should save upou some work.

HTH


"Hnelg" wrote:

Hi,

I have imported some .txt data into a Excel 2003 spreadsheet. In some
instances, I have had to copy the data from one cell below another such that
the text makes sense. However, in some instances when I do so, the cell
that is being copied to gets filled completely with the hash symbol (#).
Initially, I thought that the problem was only due to cell column width but
when I expand the width the problem still persists.

Doe anyone have any ideas?