Excel: removing figures

  exdragon 23:14 23 Jan 03
Locked
  exdragon 23:14 23 Jan 03

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 03

Make sure that Column A is formatted as text.

Then in B1 enter

=RIGHT(A1,6)

Sweet dreams!

  exdragon 23:25 23 Jan 03

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.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…