thank you guys!but i'am more prefer Excel-len-T suggestion cause i need to
use it later to create chart.
--
Regards,
Linda


"challa prabhu" wrote:

Hi,

This could be one possibility.

Do the following:

1. Select the cell, and press F2 - Edit mode.
2. Highlight the cell content.
3. Do one of the following:

On the Formatting toolbar, click the Font color icon and select the white
color from the Font color icon list.

-or-

1. On the Format menu, click Cells. The Format cells dialog bos is displayed.
2. In the Color list, select the white color.
3. Click OK, to save the settings and return to the worksheet.

Challa Prabhu


"linda" wrote:

how to display part of the cell content?example, if the cell contain 'ABCD',i
want it to view 'AB' only.can it be done?thanks in advance!

--
Regards,
Linda