Extract Characters from Left End of Cell

[Be-Rad]

I have some cells that contain either 3 or 4 characters.  I need to extract the first character if the total number of characters is 3 and extract the first 2 characters when the total number of characters if 4.  I have played around with the LEFT function but am not sophisticated enough to get the correct results.

When cell is "1234", then extract "12"

When cell is "ABC", then extract "A"

ty,

Be-Rad

[#2 · Accepted solution]

@Be-Rad 

=LEFT(A1,LEN(A1)/2)

[#3]

@Detlef Lewin 

ty so much.  appreciate you.