Excel Command

  • Thread starter Thread starter sudhir kumar
  • Start date Start date
S

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)
 
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.
 
Back
Top