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

You can use this
=left(A1, 2)
if your data starts from cell A1.

"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

If you want to change only the display and not use a formula or an extra cell
then select the "CD" in the formula bar and change the font color to match
the background color.

The "CD" will still be there, just not visible.
--
Gary''s Student - gsnu200740


"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

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

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