Neither of them are things you would do in a chart.

1 For upper, look up UPPER in Excel help.
For lower, look up LOWER in Excel help.

2 Custom format the cells as # "pcs" and just insert the number.
--
David Biddulph


"sudhir kumar" wrote in message
...
Hi friends

I want to know in excel as per followings

1. How change upper and lower case in Ms Excel.
2. How to add text with number and it calculated alos
for example :
A B C
1 4 pcs 2 pcs =sum(A1:B1)