Reducing the number of digits in a cell

**Borge14** · 08-10-2006, 05:43 AM

Hi,

Is there a way of automatically reducing the number of digits in a cell?

I have a spreadsheet containing 16,000 zip/postcodes. I need to remove the last two digits in each postcode. Is this possible?

Any help that anyone can give would be much appreciated.

Thanks,
George

Gazeta · 08-10-2006, 06:10 AM

U¿ytkownik "Borge14" <[email protected]>
napisa³ w wiadomoœci
news:[email protected]...
>
> Hi,
>
> Is there a way of automatically reducing the number of digits in a
> cell?
>
> I have a spreadsheet containing 16,000 zip/postcodes. I need to remove
> the last two digits in each postcode. Is this possible?
>
> Any help that anyone can give would be much appreciated.
>
> Thanks,
> George
>
>
=LEFT(A1;LEN(A1)-2)
works for zipcode in a1
mcg

**Borge14** · 08-10-2006, 06:15 AM

Cheers.

Although for some reason it doesn't seem to be working. Can I email you the document so you can take a look and see why that may be?

**starguy** · 08-10-2006, 06:20 AM

use comma instead of semi colon, formula should be like this

=LEFT(A1,LEN(A1)-2)

Originally Posted by Borge14

Cheers.

Although for some reason it doesn't seem to be working. Can I email you the document so you can take a look and see why that may be?

Gazeta · 08-10-2006, 06:35 AM

U¿ytkownik "Borge14" <[email protected]>
napisa³ w wiadomoœci
news:[email protected]...
>
> Cheers.
>
> Although for some reason it doesn't seem to be working. Can I email you
> the document so you can take a look and see why that may be?
>
>
> --
> Borge14
> ------------------------------------------------------------------------
> Borge14's Profile:
http://www.excelforum.com/member.php...o&userid=37324
> View this thread: http://www.excelforum.com/showthread...hreadid=570270
>

sure
mcg

**Borge14** · 08-10-2006, 06:57 AM

That works perfectly. Thanks for your help, much appreciated.

CLR · 08-10-2006, 11:35 AM

Be aware tho, that if your original number has a space between it's main
characters and the last two you wish to eliminate, the formula as given will
leave the space still there........this mod will also delete the space......

=LEFT(A1,LEN(A1)-3)

Vaya con Dios,
Chuck, CABGx3

"Borge14" wrote:

>
> Hi,
>
> Is there a way of automatically reducing the number of digits in a
> cell?
>
> I have a spreadsheet containing 16,000 zip/postcodes. I need to remove
> the last two digits in each postcode. Is this possible?
>
> Any help that anyone can give would be much appreciated.
>
> Thanks,
> George
>
>
> --
> Borge14
> ------------------------------------------------------------------------
> Borge14's Profile: http://www.excelforum.com/member.php...o&userid=37324
> View this thread: http://www.excelforum.com/showthread...hreadid=570270
>
>