Excel Command

[sudhir kumar]

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)

 

[David Biddulph]

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.