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