Tag Archives: LEFT

LEFT and RIGHT default to 1 character

The LEFT formula takes two arguments: the thing you're taking the left-hand side of, and the number of characters you want to take. So the following formula takes the first five characters of cell A1. =LEFT(A1,5) But if you only … Continue reading →