LEN formula - if string less than 3 cut off last letter

[Ace71425]

I'm looking for a formula that takes the string in A1 and if the text is 4 or greater characters I want it to display the first 3...if the text is 3 letters long I want it to display the first 2...if the text is 2 letters long I want it to display only the first character....let me know what that formula would be I'm assuming using left and len. Thanks!

 

[Br0ck]

That is odd because that is not what happens on my samples. I even tested Rick's formulas from #5 and it does the same as mine.

Excel 2010

	A	B	C	D	E	F
SAMPLE	MINE	RICK	RICK	RICK	RICK
John	Joh	Joh	Joh	Joh	Joh
Jon	Jo	Jo	Jo	Jo	Jo
Brian	Bri	Bri	Bri	Bri	Bri
Jo	J	J	J	J	J
Brianna	Bri	Bri	Bri	Bri	Bri
Kimberly	Kim	Kim	Kim	Kim	Kim
James	Jam	Jam	Jam	Jam	Jam
Billy	Bil	Bil	Bil	Bil	Bil
William	Wil	Wil	Wil	Wil	Wil
Bo	B	B	B	B	B
Jo	J	J	J	J	J
Tam	Ta	Ta	Ta	Ta	Ta
ann	an	an	an	an	an
Bob	Bo	Bo	Bo	Bo	Bo
Tammy	Tam	Tam	Tam	Tam	Tam
Joan	Joa	Joa	Joa	Joa	Joa
Roy	Ro	Ro	Ro	Ro	Ro
Wayne	Way	Way	Way	Way	Way

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]17[/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]19[/TD]

</tbody>

Sheet3​