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
If you don't mind the result being text, put this in A2:
=LEFT(A1,3)
If you want the result to be a number, put this in A2:
=VALUE(LEFT(A1,3))
--
tj
"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
"tjtjjtjt" wrote:
> If you don't mind the result being text, put this in A2:
> =LEFT(A1,3)
>
> If you want the result to be a number, put this in A2:
> =VALUE(LEFT(A1,3))
>
> --
> tj
>
>
> "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
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks