Char,Lower,Upper,Trunc,Product Function in Excel

 

Char Function

Small Letter- =CHAR(96+A2)

Capital Letter- =UPPER(CHAR(96+A2))

 

	A	B	C
1	Numbers	Small Letter	Capital Letter
2	1	a	A
3	2	b	B
4	3	c	C
5	4	d	D
6	5	e	E
7	6	f	F
8	7	g	G
9	8	h	H
10	9	i	I

 

Lower Function

 

=LOWER(A2)

 

	A	B	C	D
1	Days	Small Letter
2	SUNDAY	sunday
3	MONDAY	monday
4	TUESDAY	tuesday
5	WEDNESDAY	wednesday
6	THURSDAY	thursday
7	FRIDAY	friday

 

Upper Function

 

=UPPER(A2)

 

	A	B	C	D
1	Days	Capital Letter
2	sunday	SUNDAY
3	monday	MONDAY
4	tuesday	TUESDAY
5	wednesday	WEDNESDAY
6	thursday	THURSDAY
7	friday	FRIDAY

 

Trunc Function

 

=TRUNC(A2)

	A	B
1	Number	Trunc
2	12.256	12
3	13.247	13
4	14.532	14
5	26.145	26
6	36.145	36
7	65.745	65

 

Product Function

 

=PRODUCT(A2:B2)

 

	A	B	C
1	Number 1	Number 1	Result
2	34	45	1530
3	45	55	2475
4	58	56	3248
5	65	43	2795
6	34	67	2278
7	55	87	4785