RIGHT, LEFT and MID functions

Another helpful ones if we need just piece of data from the cells.

	A	B
1	LR279JR	=RIGHT(A1,2)
2	FI698LK	=LEFT(A2,3)
3	ZS873NB	=MID(A2,2,3)

result

	B
1	JR
2	FI6
3	S87

=RIGHT(A1,2)
A1 means where are the data
2 means how many characters we want from right side
=LEFT(A2,3)
A2 means where are the data
3 means how many characters we want from left side
=MID(A3,2,3)
A3 means where are the data
2 means that we want to start from second character
3 means how many characters we want need