Excel: removing figures

  exdragon 23:14 23 Jan 2003
Locked
  exdragon 23:14 23 Jan 2003

Hi - anyone know if this is possible, please?

Col A contains a list of about 1000 stock reference numbers, consisting of 6 digits, a decimal point and a further 6 digits. Can you remove the first 6 numbers and the decimal point?

Off to bed now, but I'll look in tomorrow. Thanks!

  VoG™ 23:19 23 Jan 2003

Make sure that Column A is formatted as text.

Then in B1 enter

=RIGHT(A1,6)

Sweet dreams!

  exdragon 23:25 23 Jan 2003

VoG™ - you're a star! I just had to wait to see if you were around.

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?