Thanks for the sugustions, It only happens on one special sheet. I can
overcome this by just copy the data to an new worksheet, everything work as
usual. ( But all cells in that sheet just cannot carries Over)

I just wonder what happen to that sheet.


"Rick Rothstein (MVP - VB)" wrote:

If you have any text in B1 (a blank space, a formula, some other text), the
text will not "carry over". You should consider either widening Column A or
formatting Column A to word wrap.

Rick

"Godwin Chan" wrote in message
...
Actually the case I face is
Cell A1 Cell B1
Cell C1
F/F & EQUIPMENTS (Compu software) ( nothing in it) Site
office

but the sheet shows
F/F & EQUIPMENTS (Compu (blank)
Site
office

The remaining text in A1 "software)" cannot carries over .


Does anyone know why text does not carrier over to the next cell.