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

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)