zipcode, enter 5, show 3
 

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

zipcode, enter 5, show 3
 

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

zipcode, enter 5, show 3
 

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

zipcode, enter 5, show 3
 

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

zipcode, enter 5, show 3
 

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