G Guest Mar 14, 2006 #1 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
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
G Guest Mar 14, 2006 #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))
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))
G Guest Mar 14, 2006 #5 thanks Duke Carey said: 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)) Click to expand...
thanks Duke Carey said: 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)) Click to expand...
