Reducing the number of digits in a cell
Użytkownik "Borge14"
napisał w wiadomości
...
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
|