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)