I want to enter 5 digit zipcode in cell a1, and want the first three
digits of that zipcode to appear in cell a2

thanks

Try =LEFT(A1,3)
--
It is nice to be important, but it is more important to be nice


"JcR" wrote:

I want to enter 5 digit zipcode in cell a1, and want the first three
digits of that zipcode to appear in cell a2

thanks

1) make sure A1 is formatted as text, in case the zip code begins with zeroes
2) in A2 enter the formula

=left(A1,3)

3) if you need the numeric value of those characters, use this formula instead

=value(left(A1,3))


"JcR" wrote:

I want to enter 5 digit zipcode in cell a1, and want the first three
digits of that zipcode to appear in cell a2

thanks

thanks

"Duke Carey" wrote:

1) make sure A1 is formatted as text, in case the zip code begins with zeroes
2) in A2 enter the formula

=left(A1,3)

3) if you need the numeric value of those characters, use this formula instead

=value(left(A1,3))


"JcR" wrote:

I want to enter 5 digit zipcode in cell a1, and want the first three
digits of that zipcode to appear in cell a2

thanks

thanks

"Miguel Zapico" wrote:

Try =LEFT(A1,3)
--
It is nice to be important, but it is more important to be nice


"JcR" wrote:

I want to enter 5 digit zipcode in cell a1, and want the first three
digits of that zipcode to appear in cell a2

thanks