Excel Help

  eivets 17:07 01 Feb 2005


A wee query here.

I have 1000s and 1000s of number in a format of 12-34567-89123-0 in an excel file.

However i want to delete the last number in all of these cells(in this case the the '0') if possible by using a formula.

Can anyone help?



  Simsy 17:16 01 Feb 2005

the formula that you need to miss out the last digit is;


this says, in English;

Look up the LEFT and LEN functions in help for an explanation.

Good luck,



  Simsy 17:23 01 Feb 2005

sorry I was about to explain it in detail, and my wife came in, so I wanted to finish the post quickly...

If you need a further explanation post back!



  eivets 17:40 01 Feb 2005

thanks simsy that worked, exactly what i was wanting.

Thanks again

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy A8 review: Hands-on

Illustrator Juan Esteban Rodriguez on creating highly detailed official film posters for Star Wars…

iMac Pro review

Meilleurs drones (2018)