zipcode, enter 5, show 3

[JcR]

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

 

[Miguel Zapico]

Try =LEFT(A1,3)

 

[Duke Carey]

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]

thanks

Try =LEFT(A1,3)

 

[JcR]

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))